Pleas help!
 

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

Pleas help!
 

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

Pleas help!
 

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

Pleas help!
 

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