Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Return Data based on Date (2003/2007)

    Help Please
    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.
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    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>
    Jerry

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

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

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •