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...