Suppose I have data in a range of B5:D50. In col B (B5:B50) I have
certain values.
Like this:

B1 tt
B2 bb
B3 gg
B4 ss
B5 pp
B6 kk
B7 bb
B8 dd
and so on... to B50

I want that when I enter any value (which is present in B5:B50) in cell
B52, formula in cell B53 should check it in range B5:B50 and return cell
name in which that value resides.
suppose I enter bb in B52 now cell B53 shoud return B2 (its cell name
in the range). Note that if values appears two times it should return
cell name of first value appeared in the range. (as in the case of bb)

thanking in anticipation of quick reply.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=538333