vLookup

  • Thread starter Thread starter vree
  • Start date Start date
V

vree

I have a worksheet that has vLookup set up in Column g; and in som
cells of the column, it returns correctly, and others, I get N/A eve
though the information is identical in nature, and it should return th
same.

Any clues
=VLOOKUP(F17,$A$3:$B$26,2) works fine in one cell, does not work i
cell immediately below, even though it should.

Thank you for your time and patience
 
Are the lookup values in column A sorted in ascending
order? That's usually where I find a problem. The other
possibility (another frequent source for me) is that the
range you've defined doesn't cover the whole actual data
range.
 
Hi
try the following
=VLOOKUP(F17,$A$3:$B$26,2,0)
to look for exact matches

HTH
Frank
 
Back
Top