Look up Contacts from Cell on Sheet

Brent.Taylor
Brent.Taylor ✭✭
in Formulas and Functions

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!

Brent

Tags:
· Share on FacebookShare on Twitter

Answers

  • 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."

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!