COMBINATION - ISNUMBER, SEARCH VLOOKUP - Experts Please!

Hi Experts,

Need some help with putting this function together for my macro...

=ISNUMBER(SEARCH(VLOOKUP

#1 I need to VLOOKUP the Customer ID ("Z") in "AirportCodes" sheet
#2 Once found (i.e. EWR) I need to use the User Defined Destination ("AA" - Sheet1) and see if it exists in any of the columns "C:U" (AirportCodes! sheet)
#3 If the user defined destination is found, then true, otherwise false.

As you can see, the chart below shows values that are FALSE but should've returned true... but it's comparing the user defined destination with the actual destination, so I am trying to come up with a solution to account for all the possible user definitions of a single location.

121212124.PNG

The AirportCodes sheet is a sheet that has 2 columns "A" is the Airport Code (ATL), column "B" is the actual location

In columns "C:U" I've added in as many different ways of spelling something as I can think of... and over time I'll continue to add more
For example:
MSP - CODE
Minneapolis/Saint Paul - Actual Location
St. Paul, STPAUL, Saint Paul, ST. Paul, St.Paul, MN, saintpaul, mn,... etc etc. etc. - User Definitions

2342346521.PNG


CAN ANYONE HELP or offer their advice? Thank you!