Can you use Index Match to search and match a cell with multiple, comma delineated values?

I have a column containing cells with multiple comma delineated values (image 1) and I want to match any/all of these values to a two column array in a separate reference sheet (image 2) and return the corresponding description from a single column array from the same reference sheet (image 3) into the product column (image 4).

Answers

  • ChristianFinke
    ChristianFinke ✭✭✭✭✭

    @wrighk22

    Smartsheet doesn’t directly support using INDEX MATCH to match multiple comma-separated values in a single cell against a reference sheet. A workaround is to split the comma-separated values into individual rows using a helper sheet or external tool like Excel. Once split, you can use INDEX MATCH or VLOOKUP to match each value to the reference sheet's CFN or GTIN column and return the corresponding description. After matching, combine the results back into a single cell using the JOIN function. This approach ensures accurate matches for all values while maintaining clarity in your data. Let me know if you’d like more details!

    CHRISTIAN FINKE

    cfinke@digitalradius.com

    Schedule a Meeting

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!