String interpretation

[Guest]

I used the Concatenate function to generate a string of this format ( =Sheet1!H9 ). Now that I have this string I just want to interpret it so it gives me the content of that cell. How to do this.

 

[Kieran]

Enclose the string result in the =Indirect() function.
You may need to remove the '=' from the start of your string.

 

[John Wilson]

Racko,

Could use a little more information here......

Let's say that A1 = "Sheet1"
Let's say that B1 = "H9"
Let's say that Sheet1!H9 = "abc"

=Concatenate(A1,B1) equals "Sheet1H9"
Not what you wanted......

With the above scenario, try the following:

=INDIRECT(CONCATENATE(A1,"!",B1))

You should get "abc"

John

I used the Concatenate function to generate a string of this format (

=Sheet1!H9 ). Now that I have this string I just want to interpret it so it
gives me the content of that cell. How to do this.

 

[Guest]

Thanks to you

You were right, must remove the "=" caracter.