Tables
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?
John
Posted by Aladin Akyurek on October 23, 2001 2:34 PM
John,
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:
=IF(C22,IF(COUNTIF(U33:U48)=1,VLOOKUP(C22,U33:V48,2,0),""),"")
0 means FALSE which is used for ab exact match. If an exact match is not required, just drop 0 from VLOOKUP.
Aladin
=======
