My formula is this: =VLOOKUP($A46,'[2020 Scorecard Realization OT.xlsx]42'!$L$29:$Q$60,6,FALSE)
It is getting the value for WEEK 42 from the 2020 Scorecard Realization File
Each week, I have to change the Week Number after the bracket in every formula to capture the next week VLOOKUP($A46,'[2020 Scorecard Realization OT.xlsx]43'!$L$29:$Q$60,6,FALSE)
I've tried to link it to my column headers showing the week number but it keeps giving me a formula error
I currently have to do an Find/Replace to change it each time. I'd rather have it done in the formula. Would rather not use macros.
Any help would be appreciated. Thank you!
It is getting the value for WEEK 42 from the 2020 Scorecard Realization File
Each week, I have to change the Week Number after the bracket in every formula to capture the next week VLOOKUP($A46,'[2020 Scorecard Realization OT.xlsx]43'!$L$29:$Q$60,6,FALSE)
I've tried to link it to my column headers showing the week number but it keeps giving me a formula error
I currently have to do an Find/Replace to change it each time. I'd rather have it done in the formula. Would rather not use macros.
Any help would be appreciated. Thank you!