I have two spreadsheets. One has the dates for a given plant phenological event. The other has the appropriate weather data for the year related to those dates.
I want to extract the data from the weather spreadsheet for the correspoding dates and add to the plant data sheet. I have attached sample data with an example colour highlighted of where the extracted data should end up.
I've tried some "ismatch" stuff but can't see a way forward. I'm sure it should be easy but I'm not making much progress.