Newbie here, all all.
I have a list of dates in a column i.e 03/06/2014 (A2)
I then have a table which has a start date in the first column Z1, an end date in the second column Z2 and a year in the third column Z3.
I want to look at the date in A2 and see where this falls within the 2 dates within Z1 and Z2. If it does return the value in Z3 into A3
Note: that there are 5 date ranges and 5 years that they can fall against
Your help would be appreciated
Bookmarks