Hi,

The lookup value AND the lookup column in the lookup table must all be of
the same data type. Either both text or both numbers. You can use the VALUE
function to convert text numbers to number but the -- trick is favored by
most of the experts here.

Although I wouldn't do it you could convert the table range, within the
formula to text instead of converting the lookup number to a value.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"VKL Narayanan" wrote:

I am trying to vlookup a number stored as text. I have verified and
reverified the formula nothing seems to be wrong, the syntex is correct and
the field references are correct, but it keeps returning for all cells #NA.
How to debug this?