MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by John on October 23, 2001 2:17 PM

OK, here is the formula I am using:

=IF(C22="","",INDEX($U$33:$V$48, MATCH(C22,$U33:$U$48,), MATCH($V$33,$U$33:$V$33,)))

I am trying to pull up a number in colum V from a single
cell in cell range V34 to V48, based on the number in
cell C22. The result I get with this formula is #N/A.
What am I doing wrong?


Posted by Aladin Akyurek on October 23, 2001 2:34 PM


Your table appears to be in U33:V48. I expect a simple VLOOKUP should do, provided that C22 is in U33:U48, if exists.

So try:


0 means FALSE which is used for ab exact match. If an exact match is not required, just drop 0 from VLOOKUP.