Vlookup using a partial text match

J

JGROVE

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...
 
T

Teethless mama

=INDEX(B1:B200,MATCH(TRUE,ISNUMBER(SEARCH(A1:A200,C1)),))

ctrl+shift+enter, not jsut enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
vlookup - find an alternative approximate match 4
Errors encountered when using If & Vlookup formulas 2
Vlookup and retrieve values 1 row below the normally retrieved val 2
Help with IF and VLookup Match Statement 1
Vlookup and return sheet name also 2
lookup/match mult values 3
Using VLookup when text isn't an exact match 3

Top