VLOOKUP FUNCTION

J

Jeff

Hey all...I'm performing a vlookup function and am having a problem. I enter
the formula looking up a numerical value in a different sheet within the same
excel file. I know the number I am looking up is in the sheet I am looking
and has a value in the column I am referencing. However, I get a "#N/A"
response. The cells are formatted the same and for all intensive purposes
the vlookup should work. In fact it works in some, but not in others, yet I
know every one of the numbers I am looking up is in there. Anyone have this
sort of problem and know how to fix it?

Thanks for your help.
 
M

Max

Try wrapping the lookup value within VALUE(),
something like:

= VLOOKUP(VALUE(F2),Sheet1!$A$1:$B$7,2,0)

Or, try adding a zero to the lookup value

= VLOOKUP(F2+0,Sheet1!$A$1:$B$7,2,0)

The above should coax Excel to recognize "text numbers"
as actual numbers (this is probably the problem)
 
Top