Vlookup issue

[Tomwireless]

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?

 

[Luke M]

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

 

[Duke Carey]

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