Formula

[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 = (e-mail address removed)
Where column C refers to hotmail I want it to look in a table and get the
answer hotmail.com

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

 

[Jason Morin]

=A1&"."&B1&"@"&C1&".com"

HTH
Jason
Atlanta, GA

 

[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))