Compare text with range

Hi dear Smartsheet community. Please help with a case.

I need to check if all part numbers in my cell are listed in database.

Result should list unknown part numbers. In my example it's 6a.

Format of part numbers presentation in a cell can be standardized, i.e. 1a, 1b, 1c or 1a 1b 1c (separator can be standardized).

I tried with JOIN(COLLECT), but it works if i check in reverse way - from Known part numbers to Equipment list. But i need to check it from Equipment list per each line.

Maybe I need to have multi-select drop down type of column? What formula will help in this case?

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!