Hello,
I have a list box which takes its values from =$O$2:$U$2
G8:G37 then find a value in another sheet based on the selection in the list box with the following code (for G8):
=IF(OFFSET(Summary!$H4,0,MATCH($J$2,Summary!$I$3:$O$3,0))<Master!$C4,Summary!$A4,"")
Dates
The dates are stored in the BoundariesTerms
BoundariesTerms!$J$1:$P$3
In row 1 is the term headers (Term 1 (column J) to Term 7 (column P))
In row 2 is the term start date
In row 3 is the term end date
In cell J4, I would like to show the start date of the term selected by the list box in J2
In cell J6 I would like to show the end date of the term selected by the list box in J2
Many thanks all
Luke
Bookmarks