INDEX/MATCH or VLOOKUP for Date Range
1) I have sheet "X" set up as shown in screenshot 1 below where I have got a start date and end date column and the week numbers associated for the date ranges.
2) I have got another sheet "Y" set up with empty week number column as shown in screenshot 2.
Please suggest me with a formula to enter in the Week number column of sheet Y such that if the start date in sheet Y falls in the data range already set out in sheet X then the corresponding Week number from the column in sheet X is automatically picked up? I guess an index/match or vlookup could do the job for me? Thanks for your help in advance!
Help Article Resources
Check out the Formula Handbook template!