Forum Discussion
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...
Thank you , So I did do that but one of the vlookups keeps returning the wrong value and I don't know why.
John Sokolowski , if your airports are in columns A and B starting from first row where are column names, when it could be
=IF(ISNUMBER(MATCH(I1,$A:$A,0)),$A$1,IF(ISNUMBER(MATCH(I1,$B:$B,0)),$B$1,"no such"))