Hey Excel Forum!
First Post so be nice!
I have 2 files, one has a ROTA with names down left, dates along top, which will be changed every week depending on people shifts.
I have a second workbook with TELEPHONY statistics for each member of staff on a given day.
Using Data Validation, I can select which claim handler i want to add information for from the list.
Then input the date i want the info for next to the name in format 23/07/2012
I then want a formula / macro (preferably formula!) to look at that persons name, search the ROTA file for their NAME down the left, AND look for the DATE along the top, and then pull the information for which shift they are doing into the TELEPHONY worbook.
e.g. if the date is in column G, and their name is in row 11, their shift would be locate din cell G11. I want the lookup(s) to give me this by searching the persons name and date, so that if these were changed to another person or date, would still find the information I want?
Any Help Please Guys!
Thanks in Advance!
Chris
Bookmarks