Try playing with this:

I put the phrase "Find Me" in a cell in the range A1:P20.


Q1: Find Me
Q2:
=ADDRESS(SUMPRODUCT((A1:P20=Q1)*ROW(1:20)),SUMPROD UCT((A1:P20=Q1)*COLUMN(A:P)))

With the phrase in C18, the formula returned: $C$18

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=516275