On sheet one I have all Company Names in column A, Addresses in column B and
City & State on column C. On a form I created on sheet two (example)

A B C D
E
1 Company Name:
2 Address:
3 City & State:
4

When I type the companies name on B1, I want B2 & B3 to change automatically
using the reference on sheet 1.
So next time I change the company name the other cells B2 & B3 will change
because the B1 cell changed.

Thank you for your help