Index/Match and indirect

Hello,

I am trying to pull information from numerous sheets in to one place depending on the month. eg: you select the month Jan 18 from a dropdown and it will then populate the data in the main data sheet.

It is somewhat similar to this https://www.excelforum.com/excel-for...-tab-name.html however this isn't quite what I want.

I need it to search by the Month selected in the dropdown, Event Action and Event Label. It would then populate the information from the total events under each heading on the main data sheet. I know it should use Match/Index and everywhere I have looked it suggest INDIRECT also, but teh examples given don't make any sense to me.

Is it possible someone can help?

I have included an example.

Try

in F4

=SUMIFS(INDIRECT("'"&TEXT($A$2,"mmm yy") &"'!$D:$D"),INDIRECT("'"&TEXT($A$2,"mmm yy") &"'!$A:$A"),$A4,INDIRECT("'"&TEXT($A$2,"mmm yy") &"'!$C:$C"),F$3)

Copy across and down

Hi Kaper,

Thanks for the prompt reply. Unfortunately it doesn't like it and just shows #REF!

Example included.

Hi John.

That does work and serves my purpose perfectly.

As always, thanks.

Suede

The #REF is caused by assuming date in A2 is TEXT (rather than it being a date): hence conversion to TEXT in formula I supplied for F & G

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.