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

[email protected],[email protected],[email protected]

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

Email                 Status 

[email protected]       Yes

[email protected]          Yes

[email protected]          Yes

[email protected]         Yes

[email protected]            Yes


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!