Excel to find key words and paste the same in Criteria column

[tinferns]

Team.. Need your help again. I believe it is possible for Excel to find key words as described by user and paste the same in the dedicated cell. And I also believe this can be done without using a Macro. Please help out on the below.. I prefer not to use Macro's if possible please.

Keyword and their expected output:

Key Words (NOT case sensitive): (This is just an example Key Word list.. actual one is approx. 20 items/values)	Result
Flight	Flight
Flights	Flight
Ticket	Air Ticket
Air Ticket	Air Ticket
Air Tickets	Air Ticket
PNR	PNR
PNR's	PNR
PNRs	PNR

Below is an example (In some cases there are 2 key words used, Excel can choose the first key word in such cases)

Description	Criteria		Expected Result
ABC bought a flight ticket paying XXX amount			Flight
XYZ bought 3 Air Tickets paying xxx amount			Air Ticket
CDE bought 1 Air Ticket vide PNR - XXXXXXX			Air Ticket

Hope to hear from you soon. Thanks.. M

 

[Peter_SSs]

Doubtful without vba (maybe even doubtful with vba) but given the new conditions could we have some fresh realistic sample data (including layout of key word location) and expected results?