partial match - Vlookup

[tandv]

I have data in below format
1. Match String where it's extract with pipe character. Raw Data in simple form with specific values.
I need to perform "Match String " against "Raw data" column and see whether it exists in Raw Data. If it exist, then I expect to return value from "Raw Data" column.
I tried with Vlookup (using wild char) but it didn;t work. Is there any other suggestion?

Match String	Raw Data	Match?
A:B|C:D|E:F	A	A
A:B|C:D|E:F	B	B
A:B|C:D|E:F	G	None

 

[Cubist]

Try:

Book1
	A	B	C
1	Match String	Raw Data	Match?
2	A:B|C:D|E:F	A	A
3	A:B|C:D|E:F	B	B
4	A:B|C:D|E:F	G	None
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=IF(ISNUMBER(FIND(B2,A2)),B2,"None")

 

[tandv]

thanks for response. I realized, column B exists in separate tab so question is slightly different. Column B "Raw Data" is unique however I expect multiple matches against column A "Match String" so result may be similar as below

Match String	Raw Data	Match?
A:B|C:D|E:F	A	A,B
A:B|C:D|E:F	B	A,B
A:B|C:D|E:F	G	None

 

[Cubist]

Which version of XL are you using?