Require OUTPUT basis 2 figures in INPUT & given Matrix

[RavindraK]

Dear Excel experts,
We have a matrix for equipment deployment for 3 different conditions in ideal scenario. And accordingly we require OUTPUT considering 2 provided figures and given matrix.

If, the INPUT figure is lies between 2 figures, OUTPUT figure is to be calculated proportionately considering provided 2 figures in INPUT and above MATRIX.
For Example,
QCs = 5 & No of Trucks inside the yard are 350, No of RTGs should be considered in between 28 & 32 considering same ratio between 4 & 6

If, the INPUT figure is beyond the maximum as per provided MATRIX, OUTPUT figure is to be calculated basis MAXIMUM figure only.
For Example,
QCs = 9 & No of Trucks inside the yard are 450, No of RTGs should be considered 37 not beyond that.

Please help me to resolve the same.

Thanks in advance.

RavindraK