Row information from a specific cell...

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have an array of information and I want to get the row
of a particular cell based on the value in that cell.
I've tried lookup, match and index and am at wits end.
For example my array is:

C1
R1 2
R2 3
R3 1
R4 0
R5 12
R6 4

I want to formulatically determine the row for a value so
for example if I select 12 than the row is 5.

Any help is greatly appreciated.
 
Back
Top