Drop down menu

[Guest]

I would like to select from a drop down menu in colum A and after selecting
the required text, colums B and C get populated with additional information.

 

[Guest]

See VLOOKUP in HELP.

Assuming your additional information is in Sheet2 columns A to C:

in B2:

=VLOOKUP(A2,Sheet2!A:C,2,0)

will return value from column B in sheet2 corresponding to A2 value

in C2:

=VLOOKUP(A2,Sheet2!A:C,3,0)

will return value from column C in sheet2 corresponding to A2 value

HTH

 

[Guest]

Thanks for the post, but it doesn't help. What I'm trying to do is when you
select a name in column A, the address shows in column B and phone number in
column C. I have set up the drop down menu to allow for a name to be
selected in A, but don't know how to get columns B and C to fill at the same
time. I have all the data for column A sitting in rows A:62-A123, column B
data is in rows B:62-B123 and column C data is also rows C:62-C123. Does
that give a bit more info?

 

[Guest]

Where is the drop down menu - which cell(s)? In the same sheet as your data?
Do you use data validation for the dropdown?

Using VLOOKUP is the frquently used way so I don't uderstand why you say it
wont't work.

 

[Guest]

The drop down menu is in A:9 - A:13 and I would like to populate B:9 - B:13
and C:9 - C:13. The data sits in the same sheet but is down at row 62 - 123.

For column A I have used validation for the dropdown.

Thanks for the help.

 

[Guest]

I thought I'd give your code another bash and hey presto - it worked! Thanks.