+ Reply to Thread
Results 1 to 9 of 9

How to get the address of cell indirectlly?

  1. #1
    Registered User
    Join Date
    10-28-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    30

    How to get the address of cell indirectlly?

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: How to get the address of cell indirectlly?

    Hi,

    Please Login or Register  to view this content.
    HTH

  3. #3
    Registered User
    Join Date
    10-28-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: How to get the address of cell indirectlly?

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

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to get the address of cell indirectlly?

    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 ?

  5. #5
    Registered User
    Join Date
    10-28-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: How to get the address of cell indirectlly?

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

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to get the address of cell indirectlly?

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

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to get the address of cell indirectlly?

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

  8. #8
    Registered User
    Join Date
    10-28-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: How to get the address of cell indirectlly?

    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.

  9. #9
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: How to get the address of cell indirectlly?

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1