Lawrence Lovell
New Member
- Joined
- Jul 15, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello all,
First time posting so please bear with me. I have gone through all the threads that I can find as well as google and YouTube, but to no prevail.
I have a vlookup with ISNA formula which is working fine, however the monthly maintenance is quite time consuming and open to human error.
The vlookup I have made is looking to another workbook in which each sheet name is respective of that day’s entry, for example ‘110723’
What I have to do at the moment is when I come to prepare the next months template is manually go in and change the sheet name within the formulas on both the lookup and the ISNA functions (red circles) for each day of the cycle and for each session of the day.
What I would like is the formula to be relative to the date as shown in the blue circle.
I have tried to learn about the indirect function but I just can’t seem to master me it when it comes to another workbook.
This is the functional formula:
=IF(ISNA(VLOOKUP([@Name],'https://moogiesltd.sharepoint.com/sites/TheRussellArms/SharedDocuments/General/The Russell Arms - Live/5. CASHING UP/2023/[Cashing up March 2022 (1) (5).xlsx]110723'!$B$62:$D$71,2,0)),"",(VLOOKUP([@Name],'https://moogiesltd.sharepoint.com/sites/TheRussellArms/SharedDocuments/General/The Russell Arms - Live/5. CASHING UP/2023/[Cashing up March 2022 (1) (5).xlsx]110723'!$B$62:$D$71,2,0)))
Any suggestions or support will be greatly appreciated.
Thank you.
Lawrence
First time posting so please bear with me. I have gone through all the threads that I can find as well as google and YouTube, but to no prevail.
I have a vlookup with ISNA formula which is working fine, however the monthly maintenance is quite time consuming and open to human error.
The vlookup I have made is looking to another workbook in which each sheet name is respective of that day’s entry, for example ‘110723’
What I have to do at the moment is when I come to prepare the next months template is manually go in and change the sheet name within the formulas on both the lookup and the ISNA functions (red circles) for each day of the cycle and for each session of the day.
What I would like is the formula to be relative to the date as shown in the blue circle.
I have tried to learn about the indirect function but I just can’t seem to master me it when it comes to another workbook.
This is the functional formula:
=IF(ISNA(VLOOKUP([@Name],'https://moogiesltd.sharepoint.com/sites/TheRussellArms/SharedDocuments/General/The Russell Arms - Live/5. CASHING UP/2023/[Cashing up March 2022 (1) (5).xlsx]110723'!$B$62:$D$71,2,0)),"",(VLOOKUP([@Name],'https://moogiesltd.sharepoint.com/sites/TheRussellArms/SharedDocuments/General/The Russell Arms - Live/5. CASHING UP/2023/[Cashing up March 2022 (1) (5).xlsx]110723'!$B$62:$D$71,2,0)))
Any suggestions or support will be greatly appreciated.
Thank you.
Lawrence
