INDEX/MATCH or VLOOKUP for Date Range

sahilhq
sahilhq ✭✭✭✭✭✭

Hi,

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!


image.png image.png


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!