Return multiple values from one search criteria


Hi!

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?

TIA!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!