IF ? from name to email-adress

Options

Hi,

I have names f.e. "Joerg Schmidt" in one cell and want to automatically change them into their email-address in the neighbour cell.

Since it concerns only <10 names it seems a simple task? With the if-formula ?

If I would build an general contact sheet could I have a formula like "lookup" ??

Hope you can help ;-) Thx

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!