Match an item in a column with cells containing multiple items and return a value


Here is a brief description of the scenario.

There's a source file (Source) with a column (Item Group) having a variable number of items listed (possibly as multiple values column) and another column with specific values (Serial) for each row (or item group). Each item is listed only in one item group.

In another file - Database - there are all the items listed in a column (Items all) and I would like to pull the Serial data from the source file if the item is matched in the cell Item Group of the source file.

What's an efficient formula for that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!