IF ? from name to email-adress

Joerg Schmidt

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

Andrée Starå

@Jörg Schmidt Novum Hospitality

Likewise, and I'm excellent!

Sorry about that!

Try this.

=IF(Ansprechpartner@row="Florian Rose";"[email protected]";

IF(Ansprechpartner@row="NAME";"EMAIL";

Did it work?

Bassam Khalil

Hi @Jörg Schmidt Novum Hospitality

Hope you are fine, it's better to use Vlookup Or Index with Match function to do that and convert it to a column formula so as much as the number of contacts you have the formula will deal with it.

Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question. and prepare the formula as per your exact column names.

Joerg Schmidt

Dear Bassam,

please find attached a screenshot of a possible sheet. Hope it helps to understand

Smartsheet.png

Andrée Starå

Hi @Jörg Schmidt Novum Hospitality

I hope you're well and safe!

Try something like this and continue the pattern.

=IF([Ansprechpartner@row="Florian Rose";"[email protected]";

IF([Ansprechpartner@row="NAME";"EMAIL";

IF([Ansprechpartner@row="NAME";"EMAIL"; and so on....

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Joerg Schmidt

Hi Andree,

good to hear from you. I am fine. Thx. You?

I tried these in the cell of the column "E-Mail"

=IF([Ansprechpartner@row="Florian Rose";"[email protected]"); ([Ansprechpartner@row="Jörg Schmidt";"[email protected]")

or

=IF([Ansprechpartner@row = "Florian Rose"; "[email protected]"]; [Ansprechpartner@row = "Jörg Schmidt"; "[email protected]"])

but somewhere a "( )" or "[ ]" is missing ? Right

Andrée Starå

@Jörg Schmidt Novum Hospitality

Likewise, and I'm excellent!

Sorry about that!

Try this.

=IF(Ansprechpartner@row="Florian Rose";"[email protected]";

IF(Ansprechpartner@row="NAME";"EMAIL";

Did it work?

Joerg Schmidt

Thank you. You are the best ;-) !!

Andrée Starå

@Jörg Schmidt Novum Hospitality

Excellent!

Thanks for the kind words! 😊

You're more than welcome!