Hi Larry

assuming that your dates are in B1:B200 and the date you're looking for is
in cell E1 the formula would be

=CELL("address",INDEX(B1:B200,MATCH(E1,B1:B200,0)) )

Cheers
JulieD

"Larry" wrote:

I want to return the cell address of a cell containing a specific value.

eg. input a date and return the cell address where that date is found