Forum Discussion

John Sokolowski's avatar
John Sokolowski
Copper Contributor
May 08, 2019

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...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
May 08, 2019

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.

  • John Sokolowski's avatar
    John Sokolowski
    Copper Contributor
    May 08, 2019

    Thank you , So I did do that but one of the vlookups keeps returning the wrong value and I don't know why.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 08, 2019

      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"))
      • John Sokolowski's avatar
        John Sokolowski
        Copper Contributor
        May 08, 2019

        This is my code

         

        I have a table on the master sheet with 2 columns.

         

        When I run the below formula for "PSE" which is supposed to = DOM it returns "INTL". the formula is taking the information from the cell above PSE on the master list and returning that value instead of the value for PSE it is giving me the value for POS .

         

        the table is sorted in alphabetical order

         

        =VLOOKUP(C2825,'Master Sheet'!$A$2:$C$75,2,TRUE)

         

         

Resources