Hello folks,  

what should be the formula in B3, to get the value shown based on input sheet ranges. 

thanks in advance.