Something like a vlookup with a range

[ADAMC]

Hi everyone. As always any help appreciated.
what I want to do an I’m sure it’s possible somehow!
Sheet 1:
Column M is a list of dates.
Sheet 2:
I would like to be able to enter a start date in A1 and an end date in B1 and underneath it will “lookup” all dates between those 2 ranges. From A3 down as well as corresponding cell in column O of sheet 1 on sheet 2 B3 down. Sort of like a vlookup but the dates may appear more than once for example there could be more than 1 01/07/2021 so I’d need to return all.
The reason I want to do this is because sheet 1 has 10 years of dates. But most often I’m only looking at roughly the next 4 weeks. The formula would mean that whenever I change the date range my linked graph would also update.
Many thanks if you’ve looked.
Adam.

 

[Fluff]

What version of Excel are you using

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also can you post some sample data, along with expected results

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[ADAMC]

Apologies. Yes I’ll fill in the details now.
Office 2013 standard.
Thanks.

 

[Fluff]

In the absence of any sample data, try in A3 copied down

=IFERROR(INDEX(Sheet1!$M$3:$M$200,AGGREGATE(15,6,(ROW(Sheet1!$M$3:$M$200)-ROW(Sheet1!$M$3)+1)/(Sheet1!$M$3:$M$200>=$A$1)/(Sheet1!$M$3:$M$200<=$B$1),ROWS(A$3:A3))),"")

 

[ADAMC]

This works great.
Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.