starheartbeam
New Member
- Joined
- Aug 8, 2018
- Messages
- 18
I have a very large excel file that I create every Monday. Many of these tabs have where i am looking at current week and last weeks information. For last week I am looking up from last weeks file. This is a very manual and slow process to have to go change the date for last week each week. Is there any way I can get this date part in the vlookup to pull from another column so I only have to change the date in one place?
Here is an example of one of the tabs.
And here is the vlookup I use as an example:
=VLOOKUP(B3,'C:\Inventory\Inventory Indicators\[Inventory Indicators 2021 (09-06).xlsm]OBJ DATA'!$B:$D,3,FALSE)
How can I get (09-06) to be pulled from another place in my current file that I only have to change in one place or always be current weeks date - 7 days
Here is an example of one of the tabs.
And here is the vlookup I use as an example:
=VLOOKUP(B3,'C:\Inventory\Inventory Indicators\[Inventory Indicators 2021 (09-06).xlsm]OBJ DATA'!$B:$D,3,FALSE)
How can I get (09-06) to be pulled from another place in my current file that I only have to change in one place or always be current weeks date - 7 days