Data Validation List - Multiple Columns

[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 ***

 

[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

 

[Chris Hankin]

Thanks Shane - I'll check out that tutorial and see how I go.



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