Forum Discussion

Daveway69's avatar
Daveway69
Copper Contributor
Jun 05, 2023

Combining INDEX MATCH Formulas

I have a cell with a dropdown list. I am trying to INDEX MATCH from 2 tables depending on what I select from the dropdown list.  Tables are called MAIN_EQUIPMENT and INSTRUMENT_ FIELD.  They are loca...
excel
Formulas and Functions
Daveway69's avatar
Daveway69
Copper Contributor
Jun 05, 2023
I tried it but you are right. It never pulled over from the other table.
  • Daveway69's avatar
    Daveway69
    Copper Contributor
    Jun 06, 2023
    I will look into that. Good suggestion.
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Jun 05, 2023
    Sorry,I am not what you intent to do.
    If for pick item easily,why not consolidate sub tables in System & FL Codes to one sheet first?
    Then it is easy to handle the dropdown box.
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 05, 2023

    Daveway69 

    To handle errors formula could be

    =IF(
    ISERROR(ROWS(INDIRECT(D4))),
    "no range",
    IFERROR(
        INDEX(
            'System & FL Codes'!F6:F466,
            MATCH(Sheet4!E4, INDIRECT(D4), 0)
        ),
        "no such value"
    )
)

Resources