Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding vlookup with dates (Excel 2000)

    Hi, I have a list. The first column contains dates that are one week apart (e.g. 7/7, 7/14, 7/21, 7/28). The next column is the week number (eg, 1,2,3). The next column contains the data I want. A user enters a date (any date) in cell A1. I would like to look down the row of dates and use the date just before the date that is greater than the entered date. (Boy that sounded complicated!)

    7/7/03 1 Cindy
    7/14/03 2 Boss
    7/21/03 3 Someone

    If the user entered, 7/15/03, I would want to get "Boss".

    Is there a way to do this in a formula. I couldn't seem to get vlookup to work!
    --cat

  2. #2
    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: Finding vlookup with dates (Excel 2000)

    If your 3 columns are in C1:E3 (change as appropriate) you could use this to get the date:

    <pre>=VLOOKUP(A1,$C$1:$E$3,3)</pre>


    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding vlookup with dates (Excel 2000)

    If the dates are in A1:A3, the week numbers in B1:B3, and the data is in C1:C3, an the user enters the date in D1, the following formula should give you what you want:

    <pre>=VLOOKUP(D1,A1:C3,3,TRUE)
    </pre>

    Legare Coleman

Posting Permissions

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