Link data
 

I have created list within drop down menus in my spreadsheet, I now want to
try and link a selection I make in that list so that other information will
pop-up in a seperate column. Example, if I select a name from a list, I want
the address to pop-up next to it.

Link data
 

Use =VLOOKUP()

see:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200824


"ectjay2009" wrote:

I have created list within drop down menus in my spreadsheet, I now want to
try and link a selection I make in that list so that other information will
pop-up in a seperate column. Example, if I select a name from a list, I want
the address to pop-up next to it.

Link data
 

what about a second drop down list which is dependent on what the user
selects from the first one?

associated with a is 1,2,3 b is 4,5,6 c is 7,8,9

so from the first list i pick b and from the second i can only choose 4,5 or
6.

How can this be done?

"Gary''s Student" wrote:

Use =VLOOKUP()

see:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200824


"ectjay2009" wrote:

I have created list within drop down menus in my spreadsheet, I now want to
try and link a selection I make in that list so that other information will
pop-up in a seperate column. Example, if I select a name from a list, I want
the address to pop-up next to it.

Link data
 

A slightly different technique would be used:

http://www.contextures.com/xlDataVal13.html#Depend


--
Gary''s Student - gsnu200825


"LiAD" wrote:

what about a second drop down list which is dependent on what the user
selects from the first one?

associated with a is 1,2,3 b is 4,5,6 c is 7,8,9

so from the first list i pick b and from the second i can only choose 4,5 or
6.

How can this be done?

"Gary''s Student" wrote:

Use =VLOOKUP()

see:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200824


"ectjay2009" wrote:

I have created list within drop down menus in my spreadsheet, I now want to
try and link a selection I make in that list so that other information will
pop-up in a seperate column. Example, if I select a name from a list, I want
the address to pop-up next to it.

Link data
 

Same site..........different page for dependent dropdowns.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 06:48:06 -0800, LiAD
wrote:

what about a second drop down list which is dependent on what the user
selects from the first one?

associated with a is 1,2,3 b is 4,5,6 c is 7,8,9

so from the first list i pick b and from the second i can only choose 4,5 or
6.

How can this be done?

"Gary''s Student" wrote:

Use =VLOOKUP()

see:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200824


"ectjay2009" wrote:

I have created list within drop down menus in my spreadsheet, I now want to
try and link a selection I make in that list so that other information will
pop-up in a seperate column. Example, if I select a name from a list, I want
the address to pop-up next to it.