G Guest Jan 6, 2004 #1 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.
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.
K Kieran Jan 6, 2004 #2 Enclose the string result in the =Indirect() function. You may need to remove the '=' from the start of your string.
Enclose the string result in the =Indirect() function. You may need to remove the '=' from the start of your string.
J John Wilson Jan 6, 2004 #3 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 Racko said: I used the Concatenate function to generate a string of this format ( Click to expand... =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.
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 Racko said: I used the Concatenate function to generate a string of this format ( Click to expand... =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.
