Calculating Sheet 1 and Sheet 2

[RustyNail]

What would be the formula for this.

Sheet 1 will have 30 names (all names different) starting at A2 through A31 (A1 will have PERSON wrote in it). Starting with b2,c2,d2, ect , 52 times(will a number in it) across the sheet (for 52 weeks of the year) totaling in the last col. Starting with b1 will have WEEK1, c1 WEEK2, ect 52 times across.

Sheet 2 will have GROUP 1 (written in a1) and 5 names under it (starting at a2,a3,a4,a5,a6). Then skip a line, GROUP2 (say in a8) and 5 more names (starting in a9,a10,a11,a12,a13). B1 will have total written in it for the for the whole page down.

There will be 6 GROUPS on sheet 2.

I need the persons total on sheet 1 (as I add to each week) to total on sheet 2 no matter where their name might be.

A persons name could be on sheet 2 more than once, but only once per GROUP. I need it to locate where the names are and total.

Thanks for any help.

 

[tactps]

Welcome:

=vlookup(A2,Sheet1!A:CA,53,false) should do it.

 

[RustyNail]

Thanks, I'll try this. I'm new to the advanced excel formulas, but I'm learning. Alot of info on this site and won't be a stranger. If this works, ray: thanks.

 

[Brian from Maui]

If the totals are in coulmn BB on Sheet1, enter in Sheet2

=INDEX(Sheet1!$BB$2:$BB31,MATCH(A2,Sheet1!$A$2:$A$31,0))