G
Guest
I hope I can explain this clearly, I'm not very excel literate.
Sheet 1: Cell A 1 thru A 16 represents at most 16 workdays during a one
month period but it is not formated like 1/15/06 rather it just has 15 to
represent the day, this is because the sheets current month is listed in B1.
Each cell in this range will be populated via a table on sheet 2 specifically
by having A1 equal D1 on sheet 2, all the way down to A16.
Sheet 2: in col A (starting in row 1) has all of the dates that a person
will be sheduled to work all the way through the year 2008 and is formatted
to look like this ->January-06. In col B I copied the same contents of col A
but I formatted to just list the date representing the day only, like this ->
15. Now, C1 equals sheet 1 B1, which is sheet 1's current month and C1 is
formatted like this -> January-06. Finally D1 thru D16 contains the formula
=vlookup(C$1,A1:B500,2,0) and all 16 in the range of D1 thru D16 should
popluted with the all of sheet 1's current months dates. However, if let's
say january-06 is the month and the workdays in January-06 are 1,
6,7,8,9,14,15,16,17,22,23,24,25,26,31 only the first date found is being
returned in all of the cells in Col D's range, in this case, for some reason
6 was found first (but this is another problem). With this said, it should
have been 1 found first running consecutively down the col, ending with the
last workday of 31.
hope this was understandable,
thank you for you help.
BD
Sheet 1: Cell A 1 thru A 16 represents at most 16 workdays during a one
month period but it is not formated like 1/15/06 rather it just has 15 to
represent the day, this is because the sheets current month is listed in B1.
Each cell in this range will be populated via a table on sheet 2 specifically
by having A1 equal D1 on sheet 2, all the way down to A16.
Sheet 2: in col A (starting in row 1) has all of the dates that a person
will be sheduled to work all the way through the year 2008 and is formatted
to look like this ->January-06. In col B I copied the same contents of col A
but I formatted to just list the date representing the day only, like this ->
15. Now, C1 equals sheet 1 B1, which is sheet 1's current month and C1 is
formatted like this -> January-06. Finally D1 thru D16 contains the formula
=vlookup(C$1,A1:B500,2,0) and all 16 in the range of D1 thru D16 should
popluted with the all of sheet 1's current months dates. However, if let's
say january-06 is the month and the workdays in January-06 are 1,
6,7,8,9,14,15,16,17,22,23,24,25,26,31 only the first date found is being
returned in all of the cells in Col D's range, in this case, for some reason
6 was found first (but this is another problem). With this said, it should
have been 1 found first running consecutively down the col, ending with the
last workday of 31.
hope this was understandable,
thank you for you help.
BD