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

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

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

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