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,

Please Login or Register  to view this content.

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...

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

If you have no means by which to identify the cell how exactly do you intend to return it ? ie what is the logic you had in mind exactly...

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

I have replied to your other thread - this thread and that bear little resemblance to one another.

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

actually "age" is not really what I will use, it's just for example.

in my real xsl I have a list of tests for example "Heat Test". The test can be repeated several times and will have the exact name "Heat Test" but with different results, thus I need the exact location of the indicated cell.

Later I will use INDIRECT function to analyze those results on another sheet.

It's really difficult explaining the exact reason for all this, but it's really will help me in my project.

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

I would advise reviewing your other thread.

As I see it there is no need to use INDIRECT (it is a Volatile function), a basic INDEX/MATCH approach will suffice.