table references
table references
(OP)
I hate having to post this question because I consider myself pretty good in Excel, but I can't for the life of me figure out how to use a table properly. What I'm trying to do is to have a table with steel beam properties. I would like to have a drop down box such that when I select the beam section from the drop down box the appropriate section properties are referenced. I've followed the tutorial for tables, but it keeps giving me a value error or a reference error. I even made the exact table that is in the example and copied their formulas, but it still isn't working.
Am I just missing a big picture thing here?
Am I just missing a big picture thing here?





RE: table references
RE: table references
which tutorial are you following? I can check if I get the same issues.
RE: table references
RE: table references
RE: table references
=LOOKUP(C1,SHAPES!A2:A275,SHAPES!C2:C275)
where SHAPES is the label of the workbook tab, it can look like,
=LOOKUP(C1,Shape,Sx)
where Shape is a column of data for the steel shapes (WXxY) and Sx is a column of data for the section modulus.