IF ? from name to email-adress
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
Help Article Resources
Check out the Formula Handbook template!