Formula

S

Simon

Can anyone help!!! Iam looking for the following formula:

Row A B C D
1 Simon Thomas Hotmail

I have the following information on a spreadsheet.

I want column D to = [email protected]
Where column C refers to hotmail I want it to look in a table and get the
answer hotmail.com

Hope someone can help????????
 
G

Guest

If your table is in Sheet2 columns A and B
With "hotmail" In column A and "hotmail.com" next to it in
column B
=A1&"."&B1&"@"&indirect("Sheet2!A"&match(C1,Sheet2!B:B,0))
 
Top