Populate data based on title(date)

[MalenSteptoe]

If I have sections of data in blocks, for instance A1:Z10, A11:Z20, and so on for I dunno 20 blocks. The first row of cells of each block is a date, currently merged but doesnt have to be.

is there a way on another sheet to have a formula set where the first line of dates can be selected via drop down (created separately) and then the corresponding data block is populated?

 

[saboh12617]

Hello,

I think offset could be used there like so :

=OFFSET(XLOOKUP(picked_date;dates_range; dates_range;;0;1);1;0;block_height; block_width)

here is a small example

 

[MalenSteptoe]

I came up with an answer. So I have a drop down of dates, along side the cells to bring data back from I have the date +1 (in the number code not date format). I use xlookup to get the data based on that reference.