It's not uncommon for a cell's value to *look* like a number but be text, so
Excel will not match it when comparing it to a real, true number. This is
espcially common when one of the numbers, or your lookup table, for instance,
comes from an external source.

You can try

=VLOOKUP(VALUE(lookup value),table,...) - which will fix it if your lookup
value is actually text.

If that doesn't work, copy a blank cell, select the first column of your
lookup table, and EditPaste SpecialAdd. That will force the lookup table
keys to be numeric.

Good luck


"D&E Communications" wrote:

What's the deal....I have legitimate data in both the lookup column as well
as the return column, both formatted as numbers, as well as my formula cell,
but upon looking up it is finding nothing. Can someone give me some common
errors to check for as far as using the VLOOKUP function?

TIA,
Greg