Forum Discussion
INDEX and MATCH with multiple drop-downs
I have drafted a monthly report which has a main dashboard sheet, along with monthly report sheet (the plan is to add additional sheets as the months progress). Within the dashboard sheet I have ...
As variant, if G3 returns sheet name
=INDEX(INDIRECT("'"&$G$3 & "'!E$2:E$36"),MATCH(F3,INDIRECT("'"&$G$3 & "'!A$2:A$36"),0))