I'm needing a function that looks for a single date within a ranged of dates
and if found, return the value of a cell within the column of the found date.
The value of the cell is text.

Any thoughts?
--
Many thanks