Excel formula to look up and get the string on an a column

[blackorchids2002]

Hello Masters,

I need help to lookup for a parse of string in a column and return.

Let say, I'll use part of the string "Amazon" and look up the value in vendor list below.

Thanks.

 

[Eric W]

Try:

Book1
	A	B	C	D
1	Transaction Description	Vendor		VENDOR LIST
2	AMAZON MKTP US*W40ZX72I3 AMZN.COM/BILLWA	AMAZON		AIR BNB
3	Paypal	Paypal		CATHAY PACIFIC
4	CATHAY PACIFIC	CATHAY PACIFIC		Paypal
5	AIR BNB	AIR BNB		AMAZON
6				xxxxx
7				xxxxx
8				xxxxx
9				xxxxx
10				xxxxx
MASTER

Cell Formulas
Range	Formula
B2:B5	B2	=LOOKUP(2^16,SEARCH($D$2:$D$10,A2),$D$2:$D$10)

I had to change the vendor list to just "AMAZON" since "AMAZON MARKETPLACE" in its entirety was not found. Also, it you leave room for expansion in your vendor table, you need to fill the empty rows with something you won't find in your descriptions.