C
chocolab61571
I made an inventory spreadsheet for my job. I would like it to look u
the feet and inches off of astrapping chart I put on another sprea
sheet and enter the appropriate gallons in column v of the inventor
for each tank onright side of inventory sheet. I am pretty sure I nee
a v lookup but I don't know how to do it. I am attatching theinventor
spreadsheet and the one with the strapping charts. This inventory i
for gallons of alcohol. I will enter the # of feet in column r and th
inches in column t. In some cases there will be a fraction of an inc
involved. let's use pg 103 for an example, If it is 26 feet and 4 1\
inches I want the formula to refer to the pg 103 strapping and look u
the # of gallons for 26'4" (34572) and the gallons for 1/2" (55), ad
them togethor and put the sum in cell v 5
Attachment filename: p & g 101 strapping.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50327
the feet and inches off of astrapping chart I put on another sprea
sheet and enter the appropriate gallons in column v of the inventor
for each tank onright side of inventory sheet. I am pretty sure I nee
a v lookup but I don't know how to do it. I am attatching theinventor
spreadsheet and the one with the strapping charts. This inventory i
for gallons of alcohol. I will enter the # of feet in column r and th
inches in column t. In some cases there will be a fraction of an inc
involved. let's use pg 103 for an example, If it is 26 feet and 4 1\
inches I want the formula to refer to the pg 103 strapping and look u
the # of gallons for 26'4" (34572) and the gallons for 1/2" (55), ad
them togethor and put the sum in cell v 5
Attachment filename: p & g 101 strapping.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=50327
