+ Reply to Thread
Results 1 to 3 of 3

Lookup via a date range

  1. 11-21-2022, 02:26 PM #1
    MadKing419
    MadKing419 is offline
    Registered User
    Join Date
    11-21-2022
    Location
    Connecticut, United States
    MS-Off Ver
    Office 365
    Posts
    1

    Lookup via a date range

    I am a youth football coach. I am trying to put use a formula to help determine which kids will be moving up for next year. I have a sheet with the following:

    Division Youngest Oldest
    Senior 6/1/2011 6/2/2009
    Junior 6/1/2013 6/2/2011
    Micro 6/1/2015 6/2/2013

    Without giving any other information one of my other sheets that I would like to fill out the 2023 Division looks like this:

    Birthdate 2023 Division
    09/13/2012
    03/22/2013
    09/18/2012
    09/17/2012
    07/18/2013
    09/19/2012
    06/01/2012
    8/2/2013
    04/21/2013
    06/15/2012
    06/29/2014
    4/30/2013
    08/16/2012
    02/22/2013
    10/01/2013
    2/18/2013
    07/15/2013
    04/18/2013
    10/18/2013
    10/23/2012
    01/05/2014,
    06/25/2013

    I'm assuming this is a VLOOKUP equation but can't quite get it to work.

    Any suggestions?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 11-21-2022, 02:38 PM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Lookup via a date range

    With your birthdays in column A starting in A2, try this in B2:

    =LOOKUP(A2,Sheet1!C$2:C$4,Sheet1!A$2:A$4)

    Drag the formula down column B.
    Reply With QuoteRegister To Reply
  3. 11-21-2022, 02:50 PM #3
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Lookup via a date range

    Excel 2016 (Windows) 64 bit
    A
    B
    C
    D
    E
    F
    G
    1
    		 Birthdate 2023 Division Age Division
    2
    9/13/2012
    		 =VLOOKUP(A2,$F$2:$G$4,2,TRUE)
    6/2/2009
    		 Senior
    3
    3/22/2013
    		 =VLOOKUP(A3,$F$2:$G$4,2,TRUE)
    6/2/2011
    		 Junior
    4
    9/18/2012
    		 =VLOOKUP(A4,$F$2:$G$4,2,TRUE)
    6/2/2013
    		 Micro
    5
    9/17/2012
    		 =VLOOKUP(A5,$F$2:$G$4,2,TRUE)
    6
    7/18/2013
    		 =VLOOKUP(A6,$F$2:$G$4,2,TRUE)
    7
    9/19/2012
    		 =VLOOKUP(A7,$F$2:$G$4,2,TRUE)
    8
    6/1/2012
    		 =VLOOKUP(A8,$F$2:$G$4,2,TRUE)
    9
    8/2/2013
    		 =VLOOKUP(A9,$F$2:$G$4,2,TRUE)
    10
    4/21/2013
    		 =VLOOKUP(A10,$F$2:$G$4,2,TRUE)
    11
    6/15/2012
    		 =VLOOKUP(A11,$F$2:$G$4,2,TRUE)
    12
    6/29/2014
    		 =VLOOKUP(A12,$F$2:$G$4,2,TRUE)
    13
    4/30/2013
    		 =VLOOKUP(A13,$F$2:$G$4,2,TRUE)
    14
    8/16/2012
    		 =VLOOKUP(A14,$F$2:$G$4,2,TRUE)
    15
    2/22/2013
    		 =VLOOKUP(A15,$F$2:$G$4,2,TRUE)
    16
    10/1/2013
    		 =VLOOKUP(A16,$F$2:$G$4,2,TRUE)
    17
    2/18/2013
    		 =VLOOKUP(A17,$F$2:$G$4,2,TRUE)
    18
    7/15/2013
    		 =VLOOKUP(A18,$F$2:$G$4,2,TRUE)
    19
    4/18/2013
    		 =VLOOKUP(A19,$F$2:$G$4,2,TRUE)
    20
    10/18/2013
    		 =VLOOKUP(A20,$F$2:$G$4,2,TRUE)
    21
    10/23/2012
    		 =VLOOKUP(A21,$F$2:$G$4,2,TRUE)
    22
    1/5/2014
    		 =VLOOKUP(A22,$F$2:$G$4,2,TRUE)
    23
    6/25/2013
    		 =VLOOKUP(A23,$F$2:$G$4,2,TRUE)
    Sheet: Sheet1
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Unique Lookup with Date Range and sum adjacent column based on same date range
    By nickpavlov in forum Excel General
    Replies: 2
    Last Post: 09-30-2022, 09:28 AM
  2. [SOLVED] How to lookup the date between two date range and return the information by the next colum
    By iampain13 in forum Excel General
    Replies: 2
    Last Post: 08-09-2022, 04:25 PM
  3. [SOLVED] Merge Vlookup & Lookup With lookup criteria of name & Date Range
    By ravishekhar89 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2021, 06:29 AM
  4. [SOLVED] Formula to return sum of values in given date range via lookup of date criteria
    By ImHorhay in forum Excel General
    Replies: 6
    Last Post: 12-17-2018, 05:45 PM
  5. [SOLVED] Nest lookup Function to lookup name between date range and return value
    By bbeards in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2018, 01:37 PM
  6. Lookup a date in a range of dates and return the Period in which the date belongs
    By Puzzlelover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-07-2013, 02:21 PM
  7. [SOLVED] lookup date within date range grid to return fiscal month value
    By tigerseye001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2012, 02:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1