Function that provides cell address

T

Tony Bender

Is there a function that will tell me which cell - within a set column
- a certain name is located?

Thanks
 
J

Jim Cone

The Address function is one way.
If the name is in column C and you are looking for "Tony" then...
=ADDRESS(MATCH("Tony",C:C,0),3)

Match returns the row, and 3 is the column.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)

..
..
..

"Tony Bender" <[email protected]>
wrote in message
Is there a function that will tell me which cell - within a set column
- a certain name is located?
Thanks
 
G

Gord Dibben

One function. There are more.

=ADDRESS(MATCH("qwerty",H:H),8)


Gord Dibben MS Excel MVP
 
Top