Thank you for your help. We are almost there. The table MortenA has set up is correct. What I am trying to accomplish is to read across as you did to "2", then read down to a specific number (the number might not be an exact number and will have to read the next higher number), then go...
I am trying to make a spreadsheet to when I put in the CFH of a piece of equipment in one cell, it totals up all the CFH and spits out a pipe size in another cell. I set up the gas table just as it appears in the 94' Plumbing Code in the spreadsheet. I used hlookup at first and it doesn't work...
