And Debra Dalgleish has some nice instructions for =vlookup() at:
http://www.contextures.com/xlFunctions02.html

estaban botas wrote:

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

--

Dave Peterson