Using a cell's value as a sheet ID reference?

Started by natelfo, April 18, 2019, 08:34:12 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

natelfo

I want to have a user defined cell that I can just punch in a number and use the value of that cell as a sheet ID reference in other formulas.  For example, If I type in 50, I want other formulas in the shape to reference Sheet.50!.  I've tried various things such as =If(Sheet.User.SheetID.Value=50,1,0), and I've tried playing around with adding parentheses, concatenating with the & sign, and no matter what Iv'e tried, I can not get it to work.  Any ideas?

Surrogate

#1
You can use SETF function for create reference. Syntax can be like this
SETF(GetRef(<target_cell>),"sheet."&User.id&"!width")short video

natelfo


Surrogate


Paul Herber

Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/