Weights

I am trying to find a formula for vlookup and sumif.
I am trying to build a spreadsheet for our drafting dept.
The weights are being calculated by hand. I think it would be easier if we had a spreadsheet.

For example, I have a channel that is C 8 x 11.5 the length is 7ft 6inch. The weight of the channel is .852 pounds per foot. I am able to calculate that in excel and come up with 86 pounds rounded. The material will change every time and the weight of the material will change every time. The length of the material will also change. I can input the length every time. What I want is to create a list where excel will do VLOOKUP and pull a different item every time something is typed in.

I have put the spreadsheets on my web page. www.mykaltx.com.
If you have any problem I have put my email on the web page.

=(R20*12+T20)*VLOOKUP(G20,Sheet2!A:B,2,FALSE)/12

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mykaltx" <mykaltx.1su5qk_1122480316.7464@excelforum-nospam.com> wrote in
message news:mykaltx.1su5qk_1122480316.7464@excelforum-nospam.com...
>
> I am trying to find a formula for vlookup and sumif.
> I am trying to build a spreadsheet for our drafting dept.
> The weights are being calculated by hand. I think it would be easier if
> we had a spreadsheet.
>
> For example, I have a channel that is C 8 x 11.5 the length is 7ft
> 6inch. The weight of the channel is .852 pounds per foot. I am able to
> calculate that in excel and come up with 86 pounds rounded. The
> material will change every time and the weight of the material will
> change every time. The length of the material will also change. I can
> input the length every time. What I want is to create a list where
> excel will do VLOOKUP and pull a different item every time something is
> typed in.
>
> I have put the spreadsheets on my web page. www.mykaltx.com.
> If you have any problem I have put my email on the web page.
>
>
> --
> mykaltx
> ------------------------------------------------------------------------
> mykaltx's Profile:
http://www.excelforum.com/member.php...o&userid=22055
> View this thread: http://www.excelforum.com/showthread...hreadid=390612
>

I have one more question. Sorry, I also want it to change when they qty changes.

Which is what cells?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mykaltx" <mykaltx.1subad_1122487513.6599@excelforum-nospam.com> wrote in
message news:mykaltx.1subad_1122487513.6599@excelforum-nospam.com...
>
> I have one more question. Sorry, I also want it to change when they qty
> changes.
>
>
> --
> mykaltx
> ------------------------------------------------------------------------
> mykaltx's Profile:
http://www.excelforum.com/member.php...o&userid=22055
> View this thread: http://www.excelforum.com/showthread...hreadid=390612
>