Vlookup issue
in [Functions]
|
From: Tomwireless on 20 Apr 2010 10:49 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
From: Luke M on 20 Apr 2010 11:13 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" <Tomwireless(a)discussions.microsoft.com> wrote in message news:930C26B4-6D11-4730-9F89-F6330D44B80E(a)microsoft.com... > 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
From: Duke Carey on 20 Apr 2010 11:50 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
|
Pages: 1 Prev: IF and Right Functions Next: Automatic update to SUM formula cell references. |