Index with Source Data on multiple sheets

[phkc070408]

I've attached a Sample Workbook. I'm trying to extract the times from Sun-Sat tabs and insert them into the Weekly Tab.

I tried an Index/Match formula, but I don't know how to select the multiple ranges of source information.

[AliGW]

Which Excel version for Mac are you using? Please update your profile, as it matters. Thanks.

[AliGW]

In B4 copied across and down:

=IFERROR(INDEX(INDIRECT(B$1&"!$B$3:$B$500"),MATCH($A4,INDIRECT(B$1&"!$A$3:$A$500"),0)),"")

[phkc070408]

Hi there: Thanks for the quick reply. Your solution worked perfectly in the sample that I gave you, however it does not work in my project. I should have pivoted the Weekly Tab, so the days of the week are along Column A. I thought pivoting these would be easy, however I'm struggling.

I'll attach a better workbook with a Week 2 tab, with things in the correct order. I apologize about this.

[phkc070408]

Just an update, I found the solution to my issue. I was in fact able to pivot the data easily. My issue was, unlike my non-sample, the tabs matched the names of the row headers that I'm pulling from, and the solution provided was built based on that. I adapted my non-sample to incorporate that, and it works!!! Thanks again

[AliGW]

For Week2 - in B4:

=IFERROR(INDEX(INDIRECT($A4&"!$B$3:$B$500"),MATCH(B$1,INDIRECT($A4&"!$A$3:$A$500"),0)),"")

Glad to have helped.

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

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[AliGW]

Thanks for the kind rep comment.