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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 05, 2023

Daveway69 

Perhaps

=(INDEX('System & FL Codes'!F6:F466,MATCH(Sheet4!E4,INDIRECT(D4),0)))
Daveway69's avatar
Daveway69
Copper Contributor
Jun 05, 2023
Wahooo.... Thank you. That looks like it works.
    • Daveway69's avatar
      Daveway69
      Copper Contributor
      Jun 05, 2023
      I tried it but you are right. It never pulled over from the other table.
      • 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.

Resources