Looking up value by closest match & determining cell address.

Hello all,

I've been pulling my hair out over this problem recently, I'm struggling to come up with a solution to size a pipe from a calculated value. See the attached sheet for a more clear explanation for this.

What I'm wanting the sheet to do is look at a calculated value, then refer to a table array. Once its found the minimum value greater than the calculated value (ie. the size up) I'd like it to identify what pipe is needed.

In the arbitrary example attached, It needs to see that the value is 273.45 then look for the smallest value above that which in this case is 288.95. From that I'd like it to return the identifier for the NB of the pipe (in this case it's 12") and return the schedule (this time schedule 80).

Alongside the table and below you can see my attempts to make it work:

1. =INDEX(B5:L28, MATCH(N4,C6:L28,-1), MATCH(N4,C6:L28,-1))
2. =ADDRESS(2,MATCH(N4,C6:L28),4,1)
3. =CELL(Address, INDEX(B5:L28, MATCH(N4,C6:L28,-1), MATCH(N4,C6:L28,-1)))

Lastly any ideas about how to approach this?