Looking up values in a table
Looking up values in a table
(OP)
I am trying to write a spreadsheet which will select a pipe based on a certain Section Modulus. I have a cell which contains a calculated section modulus based on stress. I would like to then select a pipe which has a larger section modulus than the calculated one by looking up the values in a table. Can anyone share some insight on how to do this?
Thanks,
Thanks,





RE: Looking up values in a table
There is A LOOKUP and MATCH combination which will do this easily.
RE: Looking up values in a table
RE: Looking up values in a table
List, in descending order, the moduli in cells B3 thru B20 (for example). The corresponding sizes of pipe, such as 4"dia x .25" wall, or whatever way you want to call them, are listed in A3 thru A20.
In cell C1, which will show your lookup value, =OFFSET(A2,MATCH(A1,B3:B20,-1),0)
Note the LOOKUP function is not required in this case.
RE: Looking up values in a table
RE: Looking up values in a table
I don't know what you exactly need. I thought you needed to lookup the lightest pipe, with at least the required modulus, but that is a lot more involved. I haven't had any luck with books...I usually experiment with Excell, and look at other people's work for examples. The Excell "help" is not very good, and was never improved by MS all these years.
RE: Looking up values in a table
Nowadays though we don't get printed manuals from Microsoft...
You can get great Excel help at Microsoft's public newsgroups (log into their newsserver at msnews.microsoft.com using Outlook Express).
RE: Looking up values in a table
The folks at MS have little interest in engineering applications of their Excell program. Probably not worth their time, and eats into their gargantuan profits.
RE: Looking up values in a table