Jul 14 2022 02:40 AM
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.
Jul 14 2022 02:52 AM
Jul 14 2022 02:26 PM