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

Options

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

Contact list

john.doe@abc.com,sally@abc.com,rall@abc.com


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

Email                 Status 

john.doe@abc.com       Yes

frank@abc.com          Yes

sally@abc.com          Yes

brand@abc.com         Yes

rall@abc.com            Yes

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!