[SOLVED] Select an index from a sheet

[rosenirs]

Hello. I have 12 sheets with the names of the months. In these 13 sheets I display the relevant information, but I am limited to only 6 IF. Is there a way to select data from all 12 sheets according to the month? I use this formula, but as I said I am limited to only 6 months in my case.

=IF(MONTH(E3)=1;INDEX(January!C195:AH207;2;1+DAY(E3));
IF(MONTH(E3)=2;INDEX(February!C195:AH207;2;1+DAY(E3));
IF(MONTH(E3)=3;INDEX(March!C195:AH207;2;1+DAY(E3));
IF(MONTH(E3)=4;INDEX(April!C195:AH207;2;1+DAY(E3));
IF(MONTH(E3)=5;INDEX(May!C195:AH207;2;1+DAY(E3));
IF(MONTH(E3)=6;INDEX(June!C195:AH207;2;1+DAY(E3))))))))

[JohnTopley]

Create a 2 column table with numbers 1 to 12 in first column and months (text) January to December in the second

in this example the table is in columns I:J (I1:J12)

then use

=INDEX(INDIRECT("'" & VLOOKUP(Month(e3),$I$1:$J$12,2,FALSE) & "'!C195:AH207"),2,1+DAY(E3))

[Fluff13]

Hi & welcome to the board.
Two more options

Please Login or Register  to view this content.

or some what longer, but not volatile

Please Login or Register  to view this content.

you just need to add the rest of months to the choose

[rosenirs]

Thanks to both of you. Everything you offered me works. You are great.

[Fluff13]

Glad to help & thanks for the feedback.