VLookup Not Searching the entire cell for Match
 

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

VLookup Not Searching the entire cell for Match
 

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(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?


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

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

VLookup Not Searching the entire cell for Match
 

Not in order. Look in the help index for VLOOKUP to see your error in the
missing parameter.

--
Don Guillett
SalesAid Software

"LAP" wrote in message
...
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