Vlookup issue

  • Thread starter Thread starter Tomwireless
  • Start date Start date
T

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?
 
Is the data in 'Inventory Items'!A3:A888 text only? You may have some
numbers stored as text that could be causing problems.
 
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
 
Back
Top