Try this:

=ADDRESS(8,MATCH(AO5,E5:P5,0)+4,4)

Or, to make it robust against row/column insertions:

=ADDRESS(ROWS(E1:E5)+3,MATCH(AO5,E5:P5,0)+COLUMNS( A5:D5),4)

--
Biff
Microsoft Excel MVP


"Dave F" wrote in message
...
This seems like it should be relatively straightforward but I can't
figure out a solution. Cell AO5 contains 12/1/2007. E5:P5 contains:
1/1//2007
2/1/2007
3/1/2007
4/1/2007
5/1/2007
6/1/2007
7/1/2007
8/1/2007
9/1/2007
10/1/2007
11/1/2007
12/1/2007.

I want to return the cell address three rows below row 5, which
corresponds to the value in AO5. In this case, I would want cell
address P8 returned, since P5 contains the value 12/1/2007.

Any ideas as to how to approach this problem?

Thanks.

Dave