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?