I have excel 2016.

I have two values that come out of some formulas that I want to compare to a table and output either "pipe size is ok" or "pipe size is too small".

One of the values I get is for maxed developed (dev) length and that has to be rounded up to the next larger table value. Then using that column in the table, I take the number of fixture units I have and reference that against both the pipe size and the max dev length. If the number of fixture units is larger than the max allowed for that pipe size, given the max developed length allowed then the pipe would need to be upsized. if the number of fixture units is less than allowed then the pipe size is ok.

my table basically looks like this:

`distro pipe 40 60 80 100 ...`

<=max dev length (ft)

`1/2" 2.5 2 1.5 1.5 ...`

<= max fixture units allowed

`3/4" 9.5 7.5 6.5 5.5 ...`

`1" 32 25 20 16.5 ...`

`1-1/4" 32 32 27 21 ...`

`1-1/4" 32 32 32 32 ...`

`1-1/4" 80 80 80 75 ...`

`1-1/2" 87 87 87 87 ...`

`... ....`

so given my other calculations I get a maxed developed length 49 ft for a 3/4" pipe and total fixture count of 56. my result should output "pipe size is too small"

My other issue comes in that I have multiple instances of the same value in both the meter and distro pipe columns. therefore I need an interative formula to find the value that is larger than the number of fixture units that I come up with.

I have used an index match function to round the max developed length up to the next higher column value however I cannot figure out a formula to then reference the fixture unit values.

```
=INDEX('pipe sizing charts'!$C$2:$M$2,MATCH($H$59,'pipe sizing charts'!$C$2:$M$2,1)+(LOOKUP($H$59,'pipe sizing charts'!$C$2:$M$2)<>$H$59))
```

where C2:CM are my max dev length table numbers and H59 is the max dev length of the section I am sizing