Not sure if this is possible, but here's my spreadsheet:


SHEET1
A B C D E
ZZ
1 1/5/06 1/5/06 1/12/06 1/12/06 etc. thru 12/31/06
2 Name Accr Taken Accr Taken
3 John 1.75 0 1.75 -8
4 Jack 1.75 0 1.75 0
5 Jason 1.75 -8 1.75 0

On a separate spreadsheet, I want to create a summary by name. So I would
just input a name and the amount accrued and taken would populate. Here's the
format I was hoping for (second sheet):

SHEET2

A B C

1 Name: __________ (input)
2
3 Vac Accr Vac Used
4 01/05/06 zz xx
5 01/12/06 xx xx
6 01/19/06 xx xx
etc xx xx
... xx xx
12/31/06 xx xx

I know sumproduct doesn't work, but I need something with this type of logic
in the 'zz' cell on sheet2:

sumproduct
(--(sheet1!'A3:A5=sheet2!'B1),--(sheet1!'B1:ZZ1=sheet2!'A4),sheet1!'B3:ZZ5)

Even a pivot table would be cumbersome, as there's way too many columns. Any
ideas? Thanks in advance!