# Thread: Return Data based on Date (2003/2007)

1. ## Return Data based on Date (2003/2007)

In the attached workbook, I need to return the position associated with the next training due date.
I used the min function to determine the next date and I need to return the position from the DATA sheet.
I was hoping to use a formula for this.

I'm in a spot where I can't rearrange the data sheet, I was thinking vlookup but the position is to the left of the date.

2. ## Re: Return Data based on Date (2003/2007)

Hi Stans

For my solution there will be a need to rearrange your data in the Data sheet so that the columns (starting at C10) read
Date Trained,Position,Training,Due Status.

The Date Trained list should then be sorted in order.

Then you can use the formula:

=VLOOKUP(E10,Data!C1034,2)

PS I have reformatted the dates to dd/mm/yy for my example but you can change it back to your choice <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

3. ## Re: Return Data based on Date (2003/2007)

place the formula in cell F10. This will return the Name in the Position column
INDEX(Data!D10:G34,MATCH(WTr!E10,Data!F10:F34,0),1 )

does this help?

4. ## Re: Return Data based on Date (2003/2007)

Try:
=INDEX(Data!D1134,MATCH(E10,Data!\$F\$11:\$F\$34,0))

Steve

5. ## Re: Return Data based on Date (2003/2007)

Thanks all, the indes/match worked fine

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•