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.

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.

Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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 again,

I have a new Excel question I hope you can help me with, its building on the
answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever value
satisfies both (logical arguments of the IF functions) to be True than excel
will stop at the first value that satisfies these logical IF functions.

Note if no value tend to be True than it stops with (L120*11) even if it is
giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.

Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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,

I am attaching a sample spreadsheet.

Hal.


"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.

I find this quite ironic.

HP/Compaq ripped me off of a purchase rebate and now I'm trying to solve a
problem to help HP/Compaq. I don't think so! <VBG

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello,

I am attaching a sample spreadsheet.

Hal.


"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in
ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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,

Let me rephrase my question

1. In table (A) cell (A3) I have a dropdown list that contains 6
choices from (L70*7 to L120*11)

2. Depending on the choice I select from the dropdown list 2 logical
arguments are effected

Cell (J3) (=IF(I3<=H3,TRUE,FALSE)) and Cell (K3)
(=IF(G3<=200,TRUE,FALSE)).

3. In this case the choice of (L80*8) from the dropdown list gives the
correct answer as both arguments in cell (J3 & K3) return with the answer
(TRUE) which what I want.

4. Is there a way where I can run the 6 choices in the dropdown list
like I would in a simulation?

5. Where the simulation starts with the choice (L70*7) and ends with
(L120*11).

6. When Both Cells (J3 & K3) gives the answer (TRUE) than the
simulation ends.

7. In the example I have given in (3) the simulation will end at
(L80*8). The first choice the gives (TRUE) answer.

8. If (False) answer is found in the 6 choices than the simulation
ends with L120*11.

Thank you.

Hal.


"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.

I don't quite follow. Is this message ment for this string?

Hal.


"T. Valko" wrote in message
...
I find this quite ironic.

HP/Compaq ripped me off of a purchase rebate and now I'm trying to solve a
problem to help HP/Compaq. I don't think so! <VBG

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello,

I am attaching a sample spreadsheet.

Hal.


"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building
on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in
ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if
it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.

I forgot to attach the excel spreadsheet.

Hal

"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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,

Just to clarify, the purpose for this project is to determine the correct
lateral steel bracing member for a multistory building where (L70*7) means
steel equal angle profile 70mm in length and 7mm in thickness. This is for
a Master's program course that I'm taking.

Thank you.

Hal.


"T. Valko" wrote in message
...
I find this quite ironic.

HP/Compaq ripped me off of a purchase rebate and now I'm trying to solve a
problem to help HP/Compaq. I don't think so! <VBG

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello,

I am attaching a sample spreadsheet.

Hal.


"T. Valko" wrote in message
...
Sorry, not following you on this.

???

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Hello again,

I have a new Excel question I hope you can help me with, its building
on
the answer for the last one.

I have a dropdown list in cell (A3) containing 6 values from (L70*7 to
L120*11) when I select value from the list 2 cells (J3, K3) containing
the
IF function are checked to see if the value is True or False.

What I need is for Excel to automatically check the 6 values in
ascending
order from the lowest to the highest (L70*7 to L120*11) for whichever
value satisfies both (logical arguments of the IF functions) to be True
than excel will stop at the first value that satisfies these logical IF
functions.

Note if no value tend to be True than it stops with (L120*11) even if
it
is giving a False answer.

Thank you.

Hal.


"T. Valko" wrote in message
...
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Hal" wrote in message
...
Thank you so much for all your help. The formula did work.

Hal.

"T. Valko" wrote in message
...
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.