How to get the address of cell indirectlly?

**michael.g** · 10-29-2009, 11:33 AM

Hi,

Attached is the xsl demonstrating the problem...

I would like cell H6 to have the address of the cell that C4 refers to(i.e. "C4").

how can I do it?

Thanks in advance

**JeanRage** · 10-29-2009, 11:48 AM

Hi,

="C"&MATCH(H4,C1:C8,0)

HTH

**michael.g** · 10-29-2009, 12:07 PM

Thanks, but it's NOT solves my problem as there can be several cells with the same data... See new attached file

**DonkeyOte** · 10-29-2009, 12:10 PM

based on your file

="C"&MATCH(TRUE,INDEX(B1:B8&C1:C8="Age: "&H4,0),0)

that said it's an odd request/requirement-- why do you need this ?

**michael.g** · 10-29-2009, 12:20 PM

it is some bypass to another problem I have, there none solved my problem so I'm looking for another ideas to bypass it:

http://www.excelforum.com/excel-gene...her-sheet.html

there can be several cells with "Age", so I can't base it on your idea...