Sector 1: TPE-MFM; Origin 1: TPE; Destination 1: MFM; Route 1: ?
Sector 2: ICN-KUL; Origin 2: ICN; Destination 2: KUL; Route 2: ?
Sector 3: AUH-ICN; Origin 3: AUH; Destination 3: ICN; Route 3: ?
Hi all, I would like to combine 2 excel conditions into a formula, the rationale is:
-If neither "Sector", "Origin" nor "Destination" consists "ICN", show "Route" as "UND"
e.g. TPE-MFM, Route=UND
BUT
-If "Sector", "Origin" or "Destination" consists "ICN", show "Route" as the remaining text, i.e. the non-ICN text
e.g. ICN-KUL, Route=KUL
e.g. AUH-ICN, Route=AUH
Thank you so muchhhhh!
Bookmarks