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
MVP
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
Actually.... It didn't work. Sorry. It was pulling over from the same table and not separate ones
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 05, 2023

    Daveway69 

    Your data validation list is based on

    but in Name Manager you have only few of the defined

    For not defined names formula gives #REF!, for defined returns value or #N/A if nothing is found.

    • Daveway69's avatar
      Daveway69
      Copper Contributor
      Jun 06, 2023
      I only have a couple defined as I need to removed some of the items from the dropdown selection. i.e. FIRE_AND_GAS will not be needed for my project.
      Once I understand how I can combine multiple INDEX MATCH formulas, then I intend to add to it.

Resources