Forum Discussion
John Sokolowski
May 08, 2019Copper Contributor
How to make an Array formula with multiple nested if statements ? is there a better way?
Hello, I am trying to create an IF formula that automates whether a destination is domestic or international. The destination will be entered by its airport code (BGI,LAS,) and a separate cell wi...
JKPieterse
May 08, 2019Silver Contributor
John Sokolowski If you reformat your table so it has airport code in column A and DOmestic or International in column B you can use VLOOKUP to get the information you need.