Is it possible to do a lookup in a field that has multiple data in a cell.


I want to check if the emails under contact list are present in the table below.

Contact list,,

I want to check if any of those email addresses are present in another sheet the looks like this:

Email                 Status       Yes          Yes          Yes         Yes            Yes


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!