Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4 values.
When I select the first value in list number 1 I want Excel to auto select
the first value in the other lists as well and so on for the other values.

For example, the lists in question are in columns AP, AQ, AU, AV the source
table for the list is found K223.

Thank you in advance.

Hal.

It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4 values.
When I select the first value in list number 1 I want Excel to auto select
the first value in the other lists as well and so on for the other values.

For example, the lists in question are in columns AP, AQ, AU, AV the source
table for the list is found K223.

Thank you in advance.

Hal.

Hello Ryan,

Unfortunately, I didn't find solution with the link you provided.

What I want to do is when I select the first value of the first cell, I want
Excel automatically fill the corresponding values in the next 3 cells with
values from the table below.

Thanks.

Hal.

"ryguy7272" wrote in message
...
It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4 values.
When I select the first value in list number 1 I want Excel to auto
select
the first value in the other lists as well and so on for the other
values.

For example, the lists in question are in columns AP, AQ, AU, AV the
source
table for the list is found K223.

Thank you in advance.

Hal.

Take a look at this:
http://www.cpearson.com/excel/lookups.htm
(look at the section titled Double Lookups)

If that doesn't give you what you want, send me the workbook, with specific
instructions of what you hope to achieve, and I will try to do it within the
next day or so.


Regards,
Ryan---


--
RyGuy


"Hal" wrote:

Hello Ryan,

Unfortunately, I didn't find solution with the link you provided.

What I want to do is when I select the first value of the first cell, I want
Excel automatically fill the corresponding values in the next 3 cells with
values from the table below.

Thanks.

Hal.

"ryguy7272" wrote in message
...
It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4 values.
When I select the first value in list number 1 I want Excel to auto
select
the first value in the other lists as well and so on for the other
values.

For example, the lists in question are in columns AP, AQ, AU, AV the
source
table for the list is found K223.

Thank you in advance.

Hal.

Hello,

Unfortunately, it didn't work out. I will explain to you in detail what I am
trying to do. I attached a small table to explain the problem (let me know
if you can't retrieve the attachment and I can email it to you).

I have 2 tables in the same sheet named (A) & (B), Table (A) is linked to
table (B) by drop lists.

Example when I select the value L80X8 in cell 3A I want the next cells 3B,
3C &3D to change to their corresponding values in table (B) cell 11B, 11C &
11D.

Right now I have to do this manually by going to cells 3B, 3C &3D and
selecting the right value for each from their drop down lists.

This is very tedious in large tables where this happens more than 200 times.

What I want is to link the drop down lists in Cells 3A, 3B, 3C & 3D, so when
I select a value from the drop down list in cell 3A the corresponding
correct values in cells 3B, 3C & 3D will change automatically.

Thank you.

Hal.


"ryguy7272" wrote in message
...
Take a look at this:
http://www.cpearson.com/excel/lookups.htm
(look at the section titled Double Lookups)

If that doesn't give you what you want, send me the workbook, with
specific
instructions of what you hope to achieve, and I will try to do it within
the
next day or so.


Regards,
Ryan---


--
RyGuy


"Hal" wrote:

Hello Ryan,

Unfortunately, I didn't find solution with the link you provided.

What I want to do is when I select the first value of the first cell, I
want
Excel automatically fill the corresponding values in the next 3 cells
with
values from the table below.

Thanks.

Hal.

"ryguy7272" wrote in message
...
It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4
values.
When I select the first value in list number 1 I want Excel to auto
select
the first value in the other lists as well and so on for the other
values.

For example, the lists in question are in columns AP, AQ, AU, AV the
source
table for the list is found K223.

Thank you in advance.

Hal.

You have to delete the data validation in cells B3:D3 then enter this
formula in cell B3 and drag copy across to cell D3:

=VLOOKUP($A3,$A8:$D13,COLUMNS($B3:C3),0)

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello,

Unfortunately, it didn't work out. I will explain to you in detail what I
am trying to do. I attached a small table to explain the problem (let me
know if you can't retrieve the attachment and I can email it to you).

I have 2 tables in the same sheet named (A) & (B), Table (A) is linked to
table (B) by drop lists.

Example when I select the value L80X8 in cell 3A I want the next cells 3B,
3C &3D to change to their corresponding values in table (B) cell 11B, 11C
& 11D.

Right now I have to do this manually by going to cells 3B, 3C &3D and
selecting the right value for each from their drop down lists.

This is very tedious in large tables where this happens more than 200
times.

What I want is to link the drop down lists in Cells 3A, 3B, 3C & 3D, so
when I select a value from the drop down list in cell 3A the corresponding
correct values in cells 3B, 3C & 3D will change automatically.

Thank you.

Hal.


"ryguy7272" wrote in message
...
Take a look at this:
http://www.cpearson.com/excel/lookups.htm
(look at the section titled Double Lookups)

If that doesn't give you what you want, send me the workbook, with
specific
instructions of what you hope to achieve, and I will try to do it within
the
next day or so.


Regards,
Ryan---


--
RyGuy


"Hal" wrote:

Hello Ryan,

Unfortunately, I didn't find solution with the link you provided.

What I want to do is when I select the first value of the first cell, I
want
Excel automatically fill the corresponding values in the next 3 cells
with
values from the table below.

Thanks.

Hal.

"ryguy7272" wrote in message
...
It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4
values.
When I select the first value in list number 1 I want Excel to auto
select
the first value in the other lists as well and so on for the other
values.

For example, the lists in question are in columns AP, AQ, AU, AV the
source
table for the list is found K223.

Thank you in advance.

Hal.

Hello,

Unfortunately, it didn't work out. I will explain to you in detail what I am
trying to do. I attached a small table to explain the problem (let me know
if you can't retrieve the attachment and I can email it to you).

I have 2 tables in the same sheet named (A) & (B), Table (A) is linked to
table (B) by drop lists.

Example when I select the value L80X8 in cell 3A I want the next cells 3B,
3C &3D to change to their corresponding values in table (B) cell 11B, 11C &
11D.

Right now I have to do this manually by going to cells 3B, 3C &3D and
selecting the right value for each from their drop down lists.

This is very tedious in large tables where this happens more than 200 times.

What I want is to link the drop down lists in Cells 3A, 3B, 3C & 3D, so when
I select a value from the drop down list in cell 3A the corresponding
correct values in cells 3B, 3C & 3D will change automatically.

Thank you.

Hal.

"ryguy7272" wrote in message
...

Take a look at this:
http://www.cpearson.com/excel/lookups.htm
(look at the section titled Double Lookups)

If that doesn't give you what you want, send me the workbook, with
specific
instructions of what you hope to achieve, and I will try to do it within
the
next day or so.


Regards,
Ryan---


--
RyGuy


"Hal" wrote:

Hello Ryan,

Unfortunately, I didn't find solution with the link you provided.

What I want to do is when I select the first value of the first cell, I
want
Excel automatically fill the corresponding values in the next 3 cells
with
values from the table below.

Thanks.

Hal.

"ryguy7272" wrote in message
...
It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4
values.
When I select the first value in list number 1 I want Excel to auto
select
the first value in the other lists as well and so on for the other
values.

For example, the lists in question are in columns AP, AQ, AU, AV the
source
table for the list is found K223.

Thank you in advance.

Hal.