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

in B2 =VLOOKUP($B$1,Sheet1!$A$2:$C$1000,2,FALSE)

in B3 =VLOOKUP($B$1,Sheet1!$A$2:$C$1000,3,FALSE)

does this help?


"I want to learn more" wrote in
message ...
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

change the reference to suit yours.

in B2, enter
=VLOOKUP(B1,Sheet1!$A$1:$C$7,2,0)

in B3, enter
=VLOOKUP(B1,Sheet1!$A$1:$C$7,3,0)

does this do what you want? Hope this help

regards,xlmate



"I want to learn more" wrote:

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