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

Brian

Is it possible to attach a copy of the workbook as its difficult to
understand the detail.

Martin


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533496

Yes, how can I do that, I understand attachments within the newsgroup cannot
be done?

"mrice" wrote:


Brian

Is it possible to attach a copy of the workbook as its difficult to
understand the detail.

Martin


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533496

I picked up your question at

http://www.excelforum.com/showthread...ighlight=mrice

You can attach zipped files.

Best bet is to send by e-mail via the link on my home page


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533496