=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" wrote in message
...
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?