If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|