Data Validation List - Multiple Columns

C

Chris Hankin

Hello, could someone please advise on how I can make a selection from a
drop-down box that is linked to a Data Validation List in the following
way?

Worksheets named:

Form &
Local and Global Profiles

Defined Name: Local_Profile_Name = 'Local and Global
Profiles'!$A$2:$A$66

The Worksheet named: Local and Global Profiles contains 3 columns.
Column A: Local Profile Name (A1:A66) A1 cell has the text: Local
Profile Name as a header. Column B: Corresponding Global Name (B1:B66)
B1 cell has the text: Corresonding Global Name as a header. Column C:
Incumbent (C1:C66) C1 cell has the text: Incumbent as a header. Thus,
each Local Profile Name has an associated Global Profile Name and an
Incumbent.

In the Worksheet named: Form, I have used a Data Validation List for
cells: (C10:C19). The Data Validation List = Local_Profile_Name

What I am trying to accomplish is that when I use a drop-down box on the
Worksheet named: Form in cells (C10:C19), I would like the associated
data (found in the Worksheet named: Local and Global Profiles) for my
selection to automatically populate the adjacent cells in the range
D10:E19). So, when I make a selection in cell C10, then cells D10 and
E10 are automatically populated with the associated data for that
selection.

Please follow this example to clarify:

If I use the drop-down box on the Worksheet named: Form in cell C10 and
choose 'shop assistant' (without the quotation marks)as the Local
Profile Name, I need the associated data of the Corresponding Global
Name (located in Worksheet named: Local and Global Profiles) of 'shop
supernumery' (without the quotation marks) to be automatically populated
in the worksheet named:Form in cell D10.

Also I need the associated data of the Incumbent (located in Worksheet
named: Local and Global Profiles) of 'Attendent' (without the quotation
marks) to be automatically populated in the worksheet named: Form in
cell E10.

If anyone could please help that would be greatly appreciated.

If you need further clarification, please let me know.

Kind regards,

Chris.

*** Sent via Developersdex http://www.developersdex.com ***
 
S

Shane

Hello, could someone please advise on how I can make a selection from a
drop-down box that is linked to a Data Validation List in the following
way?

Worksheets named:

Form &
Local and Global Profiles

Defined Name: Local_Profile_Name = 'Local and Global
Profiles'!$A$2:$A$66

The Worksheet named: Local and Global Profiles contains 3 columns.
Column A: Local Profile Name (A1:A66) A1 cell has the text: Local
Profile Name as a header. Column B: Corresponding Global Name (B1:B66)
B1 cell has the text: Corresonding Global Name as a header. Column C:
Incumbent (C1:C66) C1 cell has the text: Incumbent as a header. Thus,
each Local Profile Name has an associated Global Profile Name and an
Incumbent.

In the Worksheet named: Form, I have used a Data Validation List for
cells: (C10:C19). The Data Validation List = Local_Profile_Name

What I am trying to accomplish is that when I use a drop-down box on the
Worksheet named: Form in cells (C10:C19), I would like the associated
data (found in the Worksheet named: Local and Global Profiles) for my
selection to automatically populate the adjacent cells in the range
D10:E19). So, when I make a selection in cell C10, then cells D10 and
E10 are automatically populated with the associated data for that
selection.

Please follow this example to clarify:

If I use the drop-down box on the Worksheet named: Form in cell C10 and
choose 'shop assistant' (without the quotation marks)as the Local
Profile Name, I need the associated data of the Corresponding Global
Name (located in Worksheet named: Local and Global Profiles) of 'shop
supernumery' (without the quotation marks) to be automatically populated
in the worksheet named:Form in cell D10.

Also I need the associated data of the Incumbent (located in Worksheet
named: Local and Global Profiles) of 'Attendent' (without the quotation
marks) to be automatically populated in the worksheet named: Form in
cell E10.

If anyone could please help that would be greatly appreciated.

If you need further clarification, please let me know.

Kind regards,

Chris.

*** Sent via Developersdexhttp://www.developersdex.com***

It sounds to me lik you should use a VLOOKUP function. A great
tutorial is found on Debra Dalgleish's site. Here is the link to
VLOOKUP explanation.

http://www.contextures.com/xlFunctions02.html

Hope that helps.

Regards,
Shane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top