Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Complicated Match/Lookup in between dates formula?

  1. #21
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,260
    Post Thanks / Like
    Mentioned
    71 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?


    The file does not exists. If you put it back, you must share the file.
    Regards Dante Amor

  2. #22
    New Member
    Join Date
    Jul 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Quote Originally Posted by DanteAmor View Post
    The file does not exists. If you put it back, you must share the file.

    https://www.dropbox.com/s/3320yzevcg...Data.xlsx?dl=0

    Try this one. Sorry for the gap in conversation, I was traveling for business.

  3. #23
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,260
    Post Thanks / Like
    Mentioned
    71 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Try this Array formula on sheet1

    {=IFERROR(INDEX('Weekly Run Spots'!$E$2:$E$14,MAX(IF(('Weekly Run Spots'!$O$2:$O$14=E2)*('Weekly Run Spots'!$K$2:$K$14<=C2)*('Weekly Run Spots'!$L$2:$L$14>=C2),ROW('Weekly Run Spots'!$A$2:$A$14)))-1),IFERROR(INDEX('Weekly Run Spots'!$E$2:$E$14,MAX(IF(('Weekly Run Spots'!$O$2:$O$14=E2)*('Weekly Run Spots'!$L$2:$L$14=MAX(IF('Weekly Run Spots'!$L$2:$L$14)}

    Notes:
    - The dates on sheet1 in column C must contain only the date, they currently have date and time.
    - Change 14 in all ranges of the formula for the last row with data from the "Weekly Run Spots" sheet.


    Attach the file with the test:

    https://www.dropbox.com/s/2vbrgjftqd...Data.xlsx?dl=0
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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