Forum Discussion
Daveway69
Jun 05, 2023Copper Contributor
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...
Daveway69
Jun 07, 2023Copper Contributor
This worked, but is a bit long and messy.
=IFERROR(IF(D3="MAIN_EQUIPMENT",INDEX('System & FL Codes'!$B$3:$B$112,MATCH(H3,MAIN_EQUIPMENT,0)),INDEX('System & FL Codes'!$F$6:$F$466,MATCH(H3,INSTRUMENT_FIELD,0))),"")
=IFERROR(IF(D3="MAIN_EQUIPMENT",INDEX('System & FL Codes'!$B$3:$B$112,MATCH(H3,MAIN_EQUIPMENT,0)),INDEX('System & FL Codes'!$F$6:$F$466,MATCH(H3,INSTRUMENT_FIELD,0))),"")