Changing the VLOOKUP location for changes in Week

Danny318

New Member
Joined
Jun 19, 2007
Messages
44
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!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
check if you can adopt this for your use

Book1
ABC
1123
2Test4Test3Test1
340130310
Sheet1
Cell Formulas
RangeFormula
A3:C3A3=VLOOKUP(A2,INDIRECT("'"&A1&"'!A:B"),2,0)
Cells with Data Validation
CellAllowCriteria
A2:C2List='1'!$A$1:$A$5


Book1
AB
1Test110
2Test220
3Test330
4Test440
5Test550
1


Book1
AB
1Test1110
2Test2120
3Test3130
4Test4140
5Test5150
2


Book1
AB
1Test1310
2Test2320
3Test3330
4Test4340
5Test5350
3
 
Upvote 0

Forum statistics

Threads
1,213,485
Messages
6,113,931
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top