VLookup Not Searching the entire cell for Match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(G2058,'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?
 
Nel post *LAP* ha scritto:
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(G2058,'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?
Click to expand...


VLOOKUP search a value or a text in a cell. For this function "Battery" and
"AAA Battery" are two different values, this is the reason why you don't
succeed.

Maybe You should try in a different way...


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Not in order. Look in the help index for VLOOKUP to see your error in the
missing parameter.
 
Back
Top