Excel 2000:Time Sheet date lookup when a pay period is input

[Rigmarole]

HR dept. just made a really lame spreadsheet for our time sheets.<br><br>It looks good but does nothing. We actually have to manually put in everything and do all our own addition and totaling.<br><br>I'm trying to fix it.&nbsp;&nbsp;I want to do the following:<br><br>1. Enter a pay period number (1,2,3 etc) in one cell and have excel fill in the blanks for a time period (ie. &quot;15&quot; input in a cell puts &quot;06/15/00 - 06/28/00&quot; in another cell)<br><br>2. Then put each date in cells representing the days of the week (15,16,17,18,19 etc. in their own cells)<br>I have the rest figured out.<br><br>I'm assuming I can create a chart with one column for the pay period (1,2,3...) and a column for the date range and so on, but how do I refer to the chart in order to get the information placed in the cells?<br>

 

[bigpapa]

Unless I misundertand the question, sounds like the HLookup function will do what you want (for dates). I won't go through all the details here since you can search the Excel Help for HLookup and it will explain exactly how to set it up.