Look up Contacts from Cell on Sheet


I've got a bank download that has a user name in "Last, First" format and I'd like to look up the Contact so I can e-mail the data to that contact. Any suggestions?

Appreciate it!




  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    If you are just wanting to manually look up items, you can select the column that has the data in it then press CTRL+F and you can do a search for the data using Find. If you are wanting it to populate in a contact list, we will need a bit more information to help.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!