Index Match Formula help

Hi all,

I have a Sponsorship Grid which lists all the product ID#'s the sponsor purchased within a single cell (comma separated). On my list of list of products (separate grid) I want to be able to reference the sponsor using that product. If this was one sponsor to one product I'd use index/match. Any ideas for the best approach?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!