# Thread: Complicated Match/Lookup in between dates formula? Thanks: 0 Likes:  2 Post #5326585 (1)Post #5327155 (1)

1. ## Re: Complicated Match/Lookup in between dates formula?

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

2. ## Re: Complicated Match/Lookup in between dates formula?

Originally Posted by DanteAmor
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. ## 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

## User Tag List

#### Posting Permissions

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