Assign customer names based on multiple criteria

[furqan_yousuf]

I downloaded statement from bank and based on certain value in the description field I want to assign value to it. For eg. I download transactions from bank and it has 3 columns (date, description, amount) I will add 4 the column next to amount called "Customer Name". If the description contains "New York" "Manhattan" "Times Sq" the Customer Name will be NYC -- if desc contains "IL" Chicago" "O'hare" the customer name will be "Chicago City" . Excuse my english

 

[Momentman]

I may use a lookup table and set it up as below

Book4
	A	B	C	D	E	F	G	H
1	Date	Description	Amount	Customer name		Lookup Desc	City Name
2	06-Apr-21	Purchase in O'hare Airport	138	Chicago City		New york	NYC
3	14-Apr-21	sales in New york	197	NYC		Times Sq	NYC
4	14-Apr-21	Manhattan restaurant	219	NYC		Manhattan	NYC
5	13-Apr-21	Times sq School fees payment	126	NYC		IL	Chicago City
6	17-Apr-21	amzn IL	159	Chicago City		Chicago	Chicago City
7	03-Apr-21	donation - O'hare	167	Chicago City		O'hare	Chicago City
8	12-Apr-21	Fundraiser - Times Sq	160	NYC
9	31-Mar-21	maintenance charge New york	198	NYC
10
Sheet3

Cell Formulas
Range	Formula
D2:D9	D2	=IFERROR(INDEX($G$2:$G$7,MATCH(9.99E+307,SEARCH($F$2:$F$7,B2),1)),"")

 

[furqan_yousuf]

Thank you for the response. It was really helpful.

I have couple of more question, 1) how to do this in power query? 2) all three condition should match, not just 1? For eg if desc contains all three "IL" "O'Hare" "Chicago City" only then the customer will be "Chicago".

Thanks in advance.