| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup using a partial text match
I am trying to use Vlookup to find a specific set of caracters to return the
match to that set. The problem is I am trying to pull the set from a description. Example: Lookup value: ZZWTH XXX SSKLDF Array has values in cells as follows Col 1 COL 2 WTH Wheat Home Feilds Farms I need Vlookup to scan the lookup value for the WTH (that is never int he same place in the lookup value) and match that to col1 and return col2 not sure if this is possible but it would be nice to figure this one out... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup using a partial text match
=INDEX(B1:B200,MATCH(TRUE,ISNUMBER(SEARCH(A1:A200, C1)),))
ctrl+shift+enter, not jsut enter "JGROVE" wrote: I am trying to use Vlookup to find a specific set of caracters to return the match to that set. The problem is I am trying to pull the set from a description. Example: Lookup value: ZZWTH XXX SSKLDF Array has values in cells as follows Col 1 COL 2 WTH Wheat Home Feilds Farms I need Vlookup to scan the lookup value for the WTH (that is never int he same place in the lookup value) and match that to col1 and return col2 not sure if this is possible but it would be nice to figure this one out... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS? | Excel Worksheet Functions | |||
| Searching for partial text match in range | Excel Worksheet Functions | |||
| partial/absolute text match | Excel Worksheet Functions | |||
| Partial String Match & Wild Cards Using VLOOKUP | Excel Worksheet Functions | |||
| Partial String Match Using VLOOKUP | Excel Worksheet Functions | |||
Linear Mode
