Advanced Vlookup

Hi Guys, I am looking for the formula to return value for a cell which is in the range.

I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!