I am trying to do the following:
COLUMN A COLUMN B COLUMN C COLUMN D COLUMN E COLUMN F
Airline 1 Belgium Arline1 Belg. EUR
Airlinee 2 Switzerland Airline2 Switzlan EUR
Airline 3 Morrocco Aiiline 3 Morocco USD
etc.
etc.
etc.
I need to partially match COLUMN A to COLUMN C, as well as partially match COLUMN B to COLUMN D. If BOTH criteria are met, then yield the same value from COLUMN E into COLUMN F
Please help I have tried EVERYTHING!!!!!!
Bookmarks