if/then formula

[Len]

How do i make a formual for if/then using text?

Example

If cell C = Building A then cell E = 123 Building A street, no town, FL.
then cell F = phone #
If cell C = Building B then cell E = 124 Building B street, no town, FL.
then cell F = phone #

Get the idea? Can this be done?

 

[Bob Phillips]

=IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building
B","124 Building B street, no town, FL.",""))

where does phone fit in?

 

[Len]

The phone would just be another cell of information that is auto completed.

If I put in the name of the company in column A, then the address would auto
appear in then next column B, then the phone number would auto appear in the
next column C.

 

[Len]

Thanks for the help Bob, I figured it out

=IF(C2="Building A","123 Building A street, no town, FL.",IF(C2="Building
B","124 Building B street, no town, FL.",""))

where does phone fit in?

--
__________________________________
HTH

Bob

 

[Len]

Ok, it worked for the 2 arguments as listed below. Is there any way to add
more 2 arguments? I get an error if I add more than 2 argumtents.

 

[Bob Phillips]

Create a two column table of lookup values and results, and use

=VLOOKUP(C2,M2:N10,2,False)