Vlookup issue
 

When using vlookup fuction - not looking up numeric only data

=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)))

it will lookup A3 if it is a alpha or mixed but will not if it is numeric
only. Do I have to change Cell A3?
--
Thank you

Vlookup issue
 

Is the data in 'Inventory Items'!A3:A888 text only? You may have some
numbers stored as text that could be causing problems.

--
Best Regards,

Luke M
"Tomwireless" wrote in message
...
When using vlookup fuction - not looking up numeric only data

=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory
Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)))

it will lookup A3 if it is a alpha or mixed but will not if it is numeric
only. Do I have to change Cell A3?
--
Thank you

Vlookup issue
 

If the lookup range has digit-only values stored as text, you'll get the
problem you're describing. You can change the A3 references to TEXT(A3,"0")
and that will handle the problem

"Tomwireless" wrote:

When using vlookup fuction - not looking up numeric only data

=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory Items'!$A$3:$D$888,'Inventory
Items'!$C$1,FALSE)))

it will lookup A3 if it is a alpha or mixed but will not if it is numeric
only. Do I have to change Cell A3?
--
Thank you