vLookup

[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

 

[BillJ.]

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.

 

[Frank Kabel]

Hi
try the following
=VLOOKUP(F17,$A$3:$B$26,2,0)
to look for exact matches

HTH
Frank