×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

table references

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?

RE: table references

(OP)
Nevermind, I figured it out.

RE: table references

difficult to diagnose, except to tell you what the errors mean...

which tutorial are you following? I can check if I get the same issues.

RE: table references

(OP)
I used the vlookup function.  Up until this point, I've been using Excel as a programming tool and have had little need to reference more than maybe 8-12 cells, so I've always used embedded 'if' statements.  The prospect of having 300 'if' statements was a little daunting so I wanted to learn how to look up values.

RE: table references

The lookup functions are nice for that sort of thing.  I've always found it handy to label columns of data when using the lookup functions.  Then if you (or anybody else) goes back to look at or change the formulas they make more sense.  Instead of:

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources