T Tony Bender Oct 21, 2010 #1 Is there a function that will tell me which cell - within a set column - a certain name is located? Thanks
Is there a function that will tell me which cell - within a set column - a certain name is located? Thanks
J Jim Cone Oct 21, 2010 #2 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
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 Oct 21, 2010 #3 One function. There are more. =ADDRESS(MATCH("qwerty",H:H),8) Gord Dibben MS Excel MVP
