Return a value from another worksheet using an index formula

Copper Contributor

Hello,

i am trying to do what i thought was a simple return value. - turns out not for me :(

as you can see below in column b i have a set of 'dynamic' sheet names called up by a index formula. this column is dynamic and will update as the sheet names change per project. i want to return a value from the same cell everytime but on differently named worksheets -  using this column info.

exampl. 

i want to return the value in worksheet J01 Welcome Desk A601 Cell O134. 

as the worksheet changes name on a different project, i want to return the same cell value in "B4" O134

and so on and so forth down column b

 

hope that makes sense. 

StefBon_0-1657791315990.png

 

2 Replies

@StefBon 

In C2:

=IF(B2="","",INDIRECT("'"&B2&"'!O134"))

Fill down as far as you want.

@Hans Vogelaar you make it look so simple. very much appreciated.

thankyou.