Creating a List via VLookup

[sksmith2517]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to create a Workbook that has a choir roster for attendance by month. I would like to have one worksheet that lists all the singers and their voice (Soprano, Alto, Tenor, or Bass). Then on a worksheet per month have their name listed, but not their voice. The attendance dates are across the top for each month.

My question is HOW do I get the list on each month to sub total without showing their voice? I can do in a database, I(FMPro) but I must use a SS for this project. Is there a way?

Using the Sub-total function, I can create a separate page by sub-totaling their voice. Thus I get a page for Altos, and a separate page for Tenors. Super.

I've got the attendance dates across the top of the roster all based upon formulas and they are working quite well and for the following years, I'll just have to change the first date and the entire workbook is ready to go. EXCEPT for the name changes.

The names may change each month - which is why I wanted to have one worksheet with names/voices, and then lookup names on the month sheets with a separate page for each voice.

Any help will be greatly appreciated. I'm thinking it must be some sort of Lookup and If Statement combo, but I can't begin to fathom how to start. TIA

 

[katie_c]

Are you trying to subtotal voice types or just display attendance by voice type?

Why not add 12 extra columns to display the looked up voice and do the subtotals? So you would have Month1 Name, Month1 Voice, Month2 Name, Month2 Voice, etc... Then subtotal/count the voice types or do a pivot table to summarize how many altos, sopranos, etc.

-Katie