Drop down menu

S

slavenp

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.
 
T

Toppers

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
 
T

Toppers

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.
 
S

slavenp

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