change name from @cell to email in another @cell

Joerg Schmidt

Hi,

what could be the Formula in @cell "b" to insert the email address of a person whose name is written in cell "a" ?

Werner Gerstacker

Not sure, if you can achieve this with a simple formula, i.e. displaying a different property of the contact than the name.

But you could set up a 'helper table' in a separate sheet (with the contact name in the first and their email address in the second column) and do a vlookup to it.

Werner Gerstacker

Not sure, if you can achieve this with a simple formula, i.e. displaying a different property of the contact than the name.

But you could set up a 'helper table' in a separate sheet (with the contact name in the first and their email address in the second column) and do a vlookup to it.

Dustin_berg

I was able to use this formula in my sheet without a helper sheet. First, I created a First Name helper column and used the formula =LEFT([Contact]@row, FIND(" ", [Contact]@row) - 1), then I created a Last Name helper column with the formula =MID([Contact]@row, FIND(" ", [Contact]@row), 100). Finally, I created the email column and used the formula =[First Name]@row + "." + [Last Name]@row + "@email.com"