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.