Display cell name

G

Guest

Hi,
Say in cell B4 contains text "John". Based on text "John", I'd like to
display "B4" (colomn and row of cell that contains "John") in other cell. How
is the formula to do that?

Thanks.
 
G

Guest

What is the range to be searched for text "John"? If it is restricted to
column B, then
=ADDRESS(MATCH("John",$B:$B,0),2,4,1)
returns B4. If the search area contains more than one column, you have to
create a UDF, as far as I know.

Regards,
Stefi

„js†ezt írta:
 
G

Guest

Stefi,
Thanks a lot. it's help me.

rgds
js

Stefi said:
What is the range to be searched for text "John"? If it is restricted to
column B, then
=ADDRESS(MATCH("John",$B:$B,0),2,4,1)
returns B4. If the search area contains more than one column, you have to
create a UDF, as far as I know.

Regards,
Stefi

„js†ezt írta:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple functions in a single cell 3
Comparison of columns using Conditional Formatting 3
Using cell contents in Vlookup formula 3
parsing a full name out into Last, First, Middle 2
Use Text and Cell vale to reference a named range inside a formula 1
Highlight Cell Based Upon Referenced Cell Data 3
Searching based on text 7
Can a cell be turned on or off? 1

Top