Row information from a specific cell...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rearrange data from columns to rows 2
Array Formula 11
How to identify staff who has deptcode change 2
move multiple columns into single set of columns 1
How can I programatically move cell contents 2
How to modify fill handle properties? 3
VBA to set AutoFilter to List all rows with same values in column? 2
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2

Top