Conditional formatting for text?

[Kevin]

Is there a conditional formula for inserting text into specific cells?
Example: I want to insert a company name into cell B3 and I want B4 to
auto-populate the street address, then b5 the city,state,zip, b6 the phone
number, etc.
There would be approx. 5 company names in that first selection option.
Any help would be appreciated.

 

[T. Valko]

Sounds like you need to create a lookup table. See if this helps:

http://contextures.com/xlFunctions02.html