Executing an expression

[jumpulas]

I have the following:

="Get_Table_names!D"&Q8 and that should get me the value from the tab Get_Table_names in cell Q8.
What function can I use to execute the expression which I have gotten by doing aconcatenation of "Get_Table_names!D" & Q8

Thanks
Jumpulas

 

[Richard Schollar]

Hi

Try:

=INDIRECT("'Get_Table_names'!D" & Q8)

which will target the cell at row number [value of Q8] in column D of sheet Get_Table_names.

 

[lenze]

Try

=INDIRECT("Get_Table_names!D" & Q8)

lenze

 

[jumpulas]

Excellent, Thanks

Jumpulas