I'm looking for a formula to index and match(or another way) over multiple sheets to return a value. I've attached an example.
On Sheet1, cell B2 shows todays date. I'd like cells B3, B4, B5, etc.. to look at todays date go through all the sheets, find that date and return the values listed below that date. Is that possible?
I could use clarification. The upload shows 2 names returned. There are 3 names under 2/29/2018. Additionally there are blank cells under other dates.
2/19/2018
Pat J
Eric A
Josh Gaustad
Dave
It is a PTO calendar that I would clean up if I got this to work. I would have all the names listed in the top cells for each day. B2 would return the first cell from 2/19/18, B3 would return the 2nd cell from 2/19/18, B4 would return the 3rd cell and so on.
OK.
Thank you.
I can return all the data in the target 10 cell ranges even with the blanks. The sample didn't show Josh Gaustad so I wondered if that was significant.
In the attached find this formula in helper cell B2. It is the reference text for determining which sheet to target. It is important that you maintain the format of sheet names to be "mmmm yy" or this won't work.Formula:
Please Login or Register to view this content.
Then find this named formula in Name Manager. I named it PTO_Range. Referenced in the final formula is saves about 3 lines of formula code.Then this formula in B3 filled down until you get blanks.Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks