Thank you for your time everyone.
Thank you for your time everyone.
Last edited by krundes; 02-09-2017 at 11:09 AM.
Not sure if this is what you need ..
in B2
=VLOOKUP($A2,INDIRECT("'" & TEXT($G$23,"mmmm") &"'!$A$1:$AJ$54"),MATCH(B$1,INDIRECT("'" &TEXT($G$23,"mmmm") &"'!$A$1:$AJ$1"),0),0)
Copy across and down
VLOOKUP in Month tab from date in G23
Thank you.
Last edited by krundes; 02-09-2017 at 11:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks