Drop down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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?
 
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.
 
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.
 
Back
Top