XLOOKUP Using specific date ranges, accessing other tabs to obtain the data. Sample formula would be very much appreciated.

[HelenL]

Region	OfficeName	LeaseDate
South	Kent	31/12/2014
North	Rugby	01/06/2013
West	Bristol	01/06/2023

 

[Cubist]

Your post is lacking some information.

What are you looking up?
What is the look-up range?
What is the return range?

 

[HelenL]

Your post is lacking some information.

What are you looking up?
What is the look-up range?
What is the return range?

Thank you for getting back.
I'm try to extract using Xlookup a specified date range for leasse due to expire within a data range from the information held across several worksheets.
Return range. I want to extract the lease dates between a certain date range please, and then add to the result to display other details about the result, held in the tab for that OfficeName. The information is held in 12 separate tabs in Excel, 1 worksheet created for each OfficeName. I have tried very hard to work this out, but without success. Many thanks

 

[Cubist]

In order to help, we need to see the specifics. Your description is too vague.
Can you clarify which tab is provided in the first post?
Can you post an example of one of your Office Name tabs?
Can you show the expected outcome for one entry?