| 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 |
| 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 | |||
Threaded Mode
