Index Match Formula help

jamie.null@tr.com

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?

Paul Newcome

Are you able to provide a screenshot for reference?

jamie.null@tr.com

This is the Sponsor Grid - It contains the name of the company and the product ID #'s each sponsor has paid for.

This is the Product list. So I'm hoping to pull the name of the sponsor that purchased the product onto the Product List for reference.

Paul Newcome

Try something along these lines...

=JOIN(COLLECT({Source Sheet Company Column}, {Source Sheet Product # Column}, @cell = [Sponsor Product #]@row))