Search cell for partial string, return string in other cell

[brandog484]

Good afternoon, I'm new to excel and am working on a home budget. I'm looking for a formula to search the "Description" column for a list of recognized names and return that name in the "Friendly Description" column. For example, because A2 contains "RUSSOS PIZZA" I'd like B2 to contain "Russo's Pizza". A4 contains "ARBYS" so I want B4 to contain "Arby's". A3 doesn't have a restaurant name so I'd like the function to return "Uncategorized" in B3.

I've been working with the xlookup and search functions but am not having any luck. Any ideas on how I could accomplish this?

Description	Friendly Description
DEBIT CARD PURCHASE XXXXX3513 RUSSOS PIZZA CITY, STATE
DEBIT CARD PURCHASE XXXXX7116 KEYSTONE PHARMACY CITY, STATE
DEBIT CARD PURCHASE XXXXX7116 ARBYS #1205 CITY, STATE

 

[Oaktree]

Welcome to the board!

If your list of recognized names is in F2:F100, you could use:

B2 = INDEX($F$2:$F$100,MATCH(TRUE,ISNUMBER(MATCH("*"&$F$2:$F$100&"*",A1,0)),0))

or

B2 =LOOKUP(2,1/((ISNUMBER(MATCH("*"&$F$2:$F$100&"*",A1,0)))),$F$2:$F$100)