Error in vlookup result

[MJ]

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

 

[Pete_UK]

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

 

[sand]

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

 

[MJ]

Yay, thanks. This was a bit easier.

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