the individual yearly pages look like this.

September 1 2 3 4 5 6 7 8 9 10...... Total Days Absent
Tardy

Joe a t 10
1 1
Ann a a 10
2 0

The worksheet is set up by month and each persons info is inputted each
day. The whole year is setup on one worksheet.
I have no issue with the formula's on this worksheet

Next
I have put to get a summary page that looks like this:

Month/Yr Name
Name
Joe
Ann
Total Days Absent Tardy Total Days Absent
Tardy
Sept 04 21 2 1 21
1 0
Oct 04 20 0 0 20
0 0
Nov 04 22 0 1 22
1 1

Now this page is setup using vlookup for each of the cells (total days,
absent, tardy). This page works perfectly.

Now the page i am having trouble with is like so:
Name:_________________

Total Days Absent Tardy
Sept 04
Oct 04
Nov 04
Dec 04
Jan 05
Feb 05
The only cells that are to be manually entered are the persons name and
the starting month of the sequence of 6. Now the problem i am having is
get the vlookup to lookup the persons name then another to lookup the
information for the month. I basically need a vlookup inside a vlookup
i think. These commands will be done individually for the total days,
absent, and tardy columns.


--
flourboy
------------------------------------------------------------------------
flourboy's Profile: http://www.excelforum.com/member.php...o&userid=26219
View this thread: http://www.excelforum.com/showthread...hreadid=395427