Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching for partial text match in range | Excel Worksheet Functions | |||
Relpace entire address with street name only, searching with wildc | Excel Worksheet Functions | |||
Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
Identifying an item in one col/row and searching an entire spreads | Excel Worksheet Functions |