Vlookup for 12 sheets

Feb 1, 2009
Reaction score
I have a book with 12 sheets, one per month of the year.
On each sheet I have the person on duty for each day of that respective month.
I need to vlookup all of the 12 months(sheets) so that I can have on a different book a cell that tell's me who's on duty.
I know a formula that does this, but only for 6 sheets, is is possible to vlookup all the 12 months?
Thanks alot!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel sheet name 2
Ignoring Blank cells 9
Excel Monthly Spread sheet. 12
excel date problem 3
Data selection from one worksheet into a second worksheet. 1
Vlookup 5
vlookup 4
protecting all sheets in workbook 4