Return multiple values from one search criteria


I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question.

I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values.

My lookup criteria is a single date, (ex 2/28/24) but there can be multiple PTO requests.

My main sheet looks like this for the results:

Can someone help with a formula?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!