make a box to type in span

**mikey0086** · 02-07-2008, 11:43 AM

i hope this explains it better than i did in my previous post. what i would like to do is make a box to type in span and anouther to type in pounds, and have it give me an answer in anouther box from column a, which is the beam sizes. as you can see the values are not exact, so if im looking for a 2ooo pound 20 foot span(which there isnt, the # is greater which is ok, lesser is not), the right answer it should give is 10x25.4 in column a. if i asked for a 1000 pound 20 foot it should come back 0.
thanks again for your time
mikey

**jevni1974** · 02-07-2008, 02:32 PM

Hi mikey,

I have enclosed an example how you can tackle this.
It is still a bit rough, as I cannot manage to do it without storing resultsm of functions in 'helper' cells... but maybe you or someone else is able to work it out.

hope it helps

**mikey0086** · 02-07-2008, 02:49 PM

please accept my appoligy but i dont understand what you did, i am by no means even proficient in exzcel, but am in dire need of this sheet to work. any clarification would be helpfull, due to the fact that im still hacking through the help section just to understand the basic function..
again, sorry and thanks for your time
mikey

**jevni1974** · 02-08-2008, 11:03 AM

Okay,

I used the worksheet functions MATCH and OFFSET.
Excel provides help for these functions, and otherwise you can have a look at http://www.cpearson.com/excel/TablesAndLookups.aspx

I also put some comments in the excelsheet itself
Explaining what I did

And like I mentioned the solution I posted in the example file is not completely finished.. but could not figure out how to do the lookup of the pounds using the result of the lookup of the span.

so maybe someone else has an idea how solve the issue

**mikey0086** · 02-08-2008, 11:18 AM

thanks j, for your time, im a real block head when it comes to this program..... autocad, i can draw you a fart in 3d, but this, i need a helmet, thanks for your help