VLookup Not Searching the entire cell for Match
Try:
VLOOKUP("*" & G2058 & "*",'DESC TABLE'!$A$1:$A$94,1)
"LAP" wrote:
My VLookup does not search the entire cell for a match. The cell contains a
description of items. I.E. if "Battery" is in first position it matches, if
"AAA Battery" it does not find it as a match. Here is the VLookup i'm using:
=IF(ISERR(IF(SEARCH(VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC
TABLE'!$A$1:$A$94,1)))=TRUE,"",IF(SEARCH(VLOOKUP(G 2058,'DESC
TABLE'!$A$1:$A$94,1),G2058)=1,VLOOKUP(G2058,'DESC TABLE'!$A$1:$A$94,1)))
What do I need to add to have the lookup search the entire lenght of cell?
--
LAP
|