ChongMin
Structural
- Sep 13, 2006
- 15
Does the above embedded function look familiar? Then maybe you can resolve my frustration.
I used the drop down list to select a beam size. This works fine. What I am having trouble with is using the embeded CHOOSE(MATCH()) fuction to output a beam property from a spreadsheet containing many different steel sizes.
Here is a summary of what I have so far:
A (BEAM SIZE) B (AREA) D
W27 × 178 52.30 BEAM SIZE
W27 × 161 47.40 AREA
W27 × 146 42.90
In D1, I used "Data > Validation > Allow: List > Source: =A1:A3". This works fine. I am able to select a beam size.
In D2, I used "=CHOOSE(MATCH(D1,A1:A3,0),B1:B3))" to obtain the gross area of the beam I selected in D1, but it doesn't work. I am getting a "#VALUE!" error. However, if I list B1:B3 as such
"=CHOOSE(MATCH(D1,A1:A3,0),B1,B2,B3))", it works. I do not want to do this because in reality, B1:B3 is more like B1:B200 and I would rather not waste my time typing out individually B1, B2, B3, B4, B5, B6... You get the point.
Please. If anyone can help me, any suggestion will help. THANK YOU!
I used the drop down list to select a beam size. This works fine. What I am having trouble with is using the embeded CHOOSE(MATCH()) fuction to output a beam property from a spreadsheet containing many different steel sizes.
Here is a summary of what I have so far:
A (BEAM SIZE) B (AREA) D
W27 × 178 52.30 BEAM SIZE
W27 × 161 47.40 AREA
W27 × 146 42.90
In D1, I used "Data > Validation > Allow: List > Source: =A1:A3". This works fine. I am able to select a beam size.
In D2, I used "=CHOOSE(MATCH(D1,A1:A3,0),B1:B3))" to obtain the gross area of the beam I selected in D1, but it doesn't work. I am getting a "#VALUE!" error. However, if I list B1:B3 as such
"=CHOOSE(MATCH(D1,A1:A3,0),B1,B2,B3))", it works. I do not want to do this because in reality, B1:B3 is more like B1:B200 and I would rather not waste my time typing out individually B1, B2, B3, B4, B5, B6... You get the point.
Please. If anyone can help me, any suggestion will help. THANK YOU!
