DataSet:
<tbody>
</tbody>
Need help with an index-match formula with an if statement that if the gauge entered below is within the min-max of the factory codes matching row above, it should return the appropriate price. Also if it does match the factory code but falls outside the range, it should return "out of range".
Sample Output:
<tbody>
</tbody>
Any help would be much appreciated
<tbody> </tbody> |
<tbody>
</tbody>
Need help with an index-match formula with an if statement that if the gauge entered below is within the min-max of the factory codes matching row above, it should return the appropriate price. Also if it does match the factory code but falls outside the range, it should return "out of range".
Sample Output:
Factory Code | Gauge | Price |
CODE3 | 0.00380 | 1.550 |
<tbody>
</tbody>
Any help would be much appreciated