I understand how to use 3D references and currently have a formula setup as =SUM(2019:2020!K48) where I'm using the 2019 and 2020 tabs as "bookends." That's working fine. Now, though, I want to simply list the values from the same reference across those tabs. So rather than summing them, or using any other aggregation formula, I just want to list everything in B4, which contains the tab names. So I want to return, down the column,Is this possible? How can I do this?
Job1 Job2 Job3
Yes... but it's more complicated. Read teh yellow banner (top) and post a SMALL sample sheet
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I think I got the attachment here
If I understand correctly then perhaps the following in C3 (Dashboard sheet) and down will do what you want: =INDIRECT(B3&"!B3")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks