tiredExcelUser
New Member
- Joined
- Feb 9, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to build an output in my model where a user selects a tab name from a dropdown in cell A1 and cell address in cell A2 and the offset formulas automatically update. I thought this formula would work but it doesn't
=offset(CONCATENATE("'"&A1&"'!"&A2),1,0)
any help would be greatly appreciated.
I am trying to build an output in my model where a user selects a tab name from a dropdown in cell A1 and cell address in cell A2 and the offset formulas automatically update. I thought this formula would work but it doesn't
=offset(CONCATENATE("'"&A1&"'!"&A2),1,0)
any help would be greatly appreciated.