I am needing a formula that will:

1: the user will enter a specific GPM # in to cell "C5" on sheet 1. The formula will reference the chart on sheet 2 and get the row factors that is in the chart.

2: the factor is based on the GPM and the pipe size. A copy of my chart is below:

GPM Nominal Pipe Size
3/8" ½" ¾" 1" 1¼" 1½" 2"
1 2.5 0.8 0.2 0.05 0.05 0.05 0.05
2 8.5 2.8 0.5 0.2 0.05 0.05 0.05
3 17.3 5.7 1 0.3 0.1 0.05 0.05
4 28.6 9.4 1.8 0.5 0.2 0.05 0.05
5 42.2 13.8 2.6 0.7 0.3 0.1 0.05

3: The user will then enter the lengths of pipe in the spaces on sheet 1 and the formula will multiply the lengths with the corresponding factor from the chart.

(Example) Say the GPM is 2, the pie pipe sizes on the first sheet will be multiplied by the corresponding factor

3/8" ½" ¾" 1" 1¼" 1½" 2"
8.5 2.8 .5 .2 .05 .05 .05

My problem is that what ever GPM is input is the factors that need to be multiplied by.

This is just part one but I think I can figure out part 2 once part one is solved

Thanks
David