Error in vlookup result
Yay, thanks. This was a bit easier.
"sand" wrote:
Hi,
Select the column for which you had to double click on cell,go to data
menu - text to column - delimited - next - uncheck all check box - next -
finish
"Pete_UK" wrote:
Sounds like the values in your lookup table were text instead of
numbers. Rather than change them, you could make the lookup value into
a text value with something like:
=VLOOKUP(A2&"",table,column etc)
To get rid of the #N/A error you would use a construct like:
=IF(ISNA(your_formula),"",your_formula)
to return a blank instead.
Hope this helps.
Pete
On Mar 26, 10:40 am, MJ wrote:
I got a #N/A error when using the vlookup function even though I changed the
'Table_Array' column format into 'Number'. I had to double click on each
cell in the 'Table_Array' column before it worked. Is there a way to correct
this?
Thanks
|