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

On Aug 21, 5:00 pm, Chris Hankin <chris.han...@defence.gov.au> wrote:
> 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

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



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