similar function to LOOKUP?

  • Thread starter Thread starter Kieran1028
  • Start date Start date
K

Kieran1028

Okay, Match looks like it MIGHT work, but how do I take the output o
match (a number) and make it a cell reference. Match returns th
relative location of my value in the array. But I need to refer to th
cell number. So, if Match returns a value of 63, then I know that
need to refer to cell D63 in my formula, but how can I nest the Matc
output into the cell callout? D(Match(...)) or something like that?

Make sense?

Thanks,
-Kiera
 
Hi Kieran,
Did you look at my page. In any case you will have to look
at HELP as the most valued reference
OFFSET Worksheet Function
MATCH Worksheet Function

You might also look at Chip Pearson's page
http://www.cpearson.com/excel/lookups.htm

In reference to how you would find the value knowing that
you wanted the 63rd row in Column D.
=CELL(63,4) is same as =D63
=OFFSET($D$1,62, 0) is same as =D63

or back to my page since you want Column D
you should of course have to also look in HELP
=OFFSET($D$1,MATCH(B27,C$2:C$30,0)-1,0)
the zero in the MATCH is to the first value found equal
 
Back
Top