User Profile
Daveway69
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Combining INDEX MATCH Formulas
HansVogelaar Sorry for the confusion. I have my tables on sheet called 'System & FL Codes'. The tables have been named MAIN_EQUIPMENT and INSTRUMENT_FIELD. The MAIN_EQUIPMENT look-up covers cells B4:B122. The INSTRUMENT_FIELD look-up cells cover cells F6:F466 I have a dropdown list in cell D4 where I can select MAIN_EQUIPMENT or INSTRUMENT_FIELD. This then allows me to select a Function using Data Validation =INDIRECT(D4), i.e. 'Analyser System'. Sheet4!E4 is the reference cell. If that shows 'Analyser System', then cell I4 returns 'AA' from matching in the table. The formula in cell I4 is =(INDEX('System & FL Codes'!F6:F466,MATCH(Sheet4!E4,INSTRUMENT_FIELD,0))) works. (Image above) If I use the formula =(INDEX('System & FL Codes'!B3:B112,MATCH(Sheet4!E4,MAIN_EQUIPMENT,0))) than that works for the MAIN_EQUIPMENT list. My problem is that I want to combine those 2 formulas so that they work with a dropdown list in cell D4.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 located on 'System & FL Codes' tab. The independent formulas below work, but is there a way to join them together? MAIN_EQUIPMENT index match formula =(INDEX('System & FL Codes'!B3:B112,MATCH(Sheet4!E4,MAIN_EQUIPMENT,0))) INSTRUMENT_ FIELD index match formula =(INDEX('System & FL Codes'!F6:F466,MATCH(Sheet4!E4,INSTRUMENT_FIELD,0)))
