muhleebbin
Active Member
- Joined
- Sep 30, 2017
- Messages
- 252
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
- MacOS
- Mobile
- Web
Hi,
A traditional vlookup would look like the following:
VLOOKUP(Report!$D23,'Test 1'!$A$3:$AZ$300,Report!F$19,FALSE
Is there a way where the sheet 'Test 1' could be governed by a cell on another sheet "Variable" cell E1? I found code that could vlookup across multiple sheets however one requirement was the same order of columns, because this is for an accounting project, the number of columns will increase as the year passes and I wasn't sure if that would still fit the requirement.
Thanks in advance for your help!
A traditional vlookup would look like the following:
VLOOKUP(Report!$D23,'Test 1'!$A$3:$AZ$300,Report!F$19,FALSE
Is there a way where the sheet 'Test 1' could be governed by a cell on another sheet "Variable" cell E1? I found code that could vlookup across multiple sheets however one requirement was the same order of columns, because this is for an accounting project, the number of columns will increase as the year passes and I wasn't sure if that would still fit the requirement.
Thanks in advance for your help!