Formula for Contacts

jpaulk

Hello, is it possible to come up with a way to use Contains function against the Contact Information? looking to be able to use partial information (email address) in one sheet to compare to a column in another sheet to get other contact information, such as the contact name?

Partial Match — Smartsheet Community