Error in vlookup result
 

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

Error in vlookup result
 

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

Error in vlookup result
 

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

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