Formula
 

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

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

"

HTH
Jason
Atlanta, GA

-----Original Message-----
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 =
Where column C refers to hotmail I want it to look in a
table and get the
answer hotmail.com

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

.

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


-----Original Message-----
"

HTH
Jason
Atlanta, GA

-----Original Message-----
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 =
Where column C refers to hotmail I want it to look in a
table and get the
answer hotmail.com

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

.

.