Will an INDIRECT formula combined with a VLOOKUP work?

Hello
I have a workbook that has a master sheet and will have a sheet for each day of the year that will contain data.
As you can see in the attached example, I have a "Master" sheet and on there I would like to look for a sheet that matches cell "B1" and then pulls from that sheet to match the Employee in "A2"

The finished "Master" list will have a couple hundred employees and the sheets for each day may not contain all of the employees or be in the same order.

I have used an INDIRECT formula to locate the sheet but when I try combining that with a VLOOKUP I cannot get it to work. Am I going about this the wrong way?
Any assistance will be greatly appreciated. Thanks

Master tracking example.xlsx

B4:

Formula:

Please Login or Register  to view this content.

Copy down and across

Regards, TMS

I note that you have been on the board since a solution was provided.

I am interested to know if it resolved your problem.

Regards, TMS

So the original question is answered and solved? Suggest that you mark it so.

Is there a way around this?

New question ... new thread? The formulae provided are relatively instantaneous with the small sample provided. INDIRECT is a volatile function, so I guess the calculation time will pretty much depend on how many sheets, rows, columns and cells utilise such a formula.

http://msdn.microsoft.com/en-us/libr.../bb687891.aspx

Regards, TMS





If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.