To find the address, you need to know which cell the value "mark" is in.
If you know that (and assuming it is C4), then use:

=CELL("address",C4)

If you use some formula then use:
=ADDRESS(MATCH("mark",C:C),3)
here, we know before hand that "mark" lies in column C and so use 3,
and match "mark" in column C to get the row number. You could reverse
it for unknown column position, and a known row.


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=386737