Dropdown lists in Excel

[Hal]

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.

 

[Guest]

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

 

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

 

[Guest]

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---
(e-mail address removed)

 

[T. Valko]

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

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

 

[Hal]

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

Hal.

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

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

Sorry, not following you on this.

???

 

[T. Valko]

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>

 

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

 

[Hal]

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

Hal.

 

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