Drop down menu
 

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.

Drop down menu
 

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




"slavenp" wrote:

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.

Drop down menu
 

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?

"Toppers" wrote:

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




"slavenp" wrote:

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.

Drop down menu
 

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.

"slavenp" wrote:

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?

"Toppers" wrote:

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




"slavenp" wrote:

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.

Drop down menu
 

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.

"Toppers" wrote:

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.

"slavenp" wrote:

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?

"Toppers" wrote:

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




"slavenp" wrote:

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.

Drop down menu
 

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

"slavenp" wrote:

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?

"Toppers" wrote:

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




"slavenp" wrote:

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.