G
Guest
Guest
I have a table of pipe sizes. The left column lists the pipe diameter. The first row list the pipe schedule (wall thickness). The body of the table lists the weight per foot for each pipe diameter/wall thickness combination. My estimating spread sheet (material takeoff) lists pipe quantities and pipe sizes. How do I write a Lookup formula that will return the weight per foot if I enter the pipe diameter and quantity. I think I need a combination Vlookup/Hlookup formula but I can't make mine return the value.