Hi All,
I'm wanting to lookup a value from 2 separate cell values one being height and the other width - to find a match in a pricing matrix. If this can be done at all.
E.g - 717 x 448 = $36.06
<tbody>
</tbody>
Matrix
<tbody>
</tbody>
<tbody>
</tbody>
I'm wanting to lookup a value from 2 separate cell values one being height and the other width - to find a match in a pricing matrix. If this can be done at all.
E.g - 717 x 448 = $36.06
<tbody> </tbody> |
<tbody>
</tbody>
Matrix
WIDTH | 0 - 150mm | 151 - 300 | 301 - 400 | 401 - 450 |
HEIGHT | ||||
100 - 300 | $25.92 | $26.85 | $27.97 | $28.52 |
301 - 400 | $28.05 | $27.97 | $29.45 | $30.20 |
401 - 450 | $28.62 | $28.52 | $30.20 | $31.04 |
451 - 600 | $30.33 | $30.20 | $32.43 | $33.55 |
601 - 750 | $32.04 | $31.87 | $34.66 | $36.06 |
751 - 900 | $33.75 | $33.55 | $36.90 | $38.57 |
901 - 1050 | $35.46 | $35.22 | $39.13 | $41.08 |
<tbody>
</tbody>
<tbody>
</tbody>