Referencing a chosen date in Index/Match function


I am looking to reference a date of my choosing from my sheet summary (shown below)

(want to be able to edit the date value to filter the data based on certain weeks) in my Index/Match function, I have it set up currently so that it works using the "current week" but I would like to adjust this so that myself or another user can adjust the week in this sheet without having to change it in the other sheets.

Here is the current function:

This function pulls from the "current week" as shown in screenshot below, I would like to instead use the "week ending date" from my sheet summary to select a week from this list below as the row to pull the data from, is this possible? Thank you for the help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!