Lookup value between two dates

[Creative_tree88]

I have a dataset (sample linked to this post) - I need to lookup a value from another dataset based on the column called 'KEY'.  If there is a corresponding match in the other dataset to the KEY, between Meet 1 and Meet 2 dates, then I need it to return the value it has found.  Should there not be two dates (as in the sample here) then I need to us only the Meet 1 data.

If dates Meet 1 and Meet 2 are the same dates, then I just need one of them to use for the lookup to work.

What's the best way to do this?  Can anyone help with suggesting sample DAX, or other means, to be able to achieve this? 

I've shown you what I am hoping to achieve by adding the desired result in orange, on the Data tab (only shown first 5 lines of data as an example of what I need to achieve - obviously the main data is much larger!)

I'd like the lookup to return the exam and the event date which corresponds to the date range.

Sample Data 

As always, your help is so valuable.

[BIswajit_Das · Accepted solution]

Hello @Creative_tree88 
You can create two columns like
(Here 'Table1' is 'Lookup Data' and 'Table2' is 'Data' table)

Thanks & Regards ...