Based on two inputs, the first input needs to be matched with one array, second input also needs to be matched with another array, and both values shu

[Vikram J B]

The Input Values to be entered ..IN F2 & F4. The Value in F2 needs to be searched in the array G14:K19 AND the value Entered in F4 needs to be searched in the array L14:P19. If both the values are found on the same Row and corresponding columns , We need the corresponding Model to be returned. There is an instance of F2 in K12 of the Head Range array but the corresponding cell to it in the Corresponding Discharge Value Array is P12 is not equal to F4 and hence needs to be ignored. Only the cells matching F2 head range array and F4 Matching cells lying in the same column and row no as F2 in the head Range should return the value of the model in column E


[TABLE="width: 979"]
<colgroup><col span="2"><col><col span="11"></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 4"]Criteria to Select Pumpsets [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Input Head due to all causes[/TD]
[TD]110[/TD]
[TD]in Mtrs [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Input Required Discharge [/TD]
[TD]400[/TD]
[TD]in LPM [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Head Range[/TD]
[TD="colspan: 5"] Discharge Range[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SERIES[/TD]
[TD]MODEL[/TD]
[TD]STG[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE68[/TD]
[TD]RE68/03+ET075[/TD]
[TD]3[/TD]
[TD]62[/TD]
[TD]60[/TD]
[TD]57[/TD]
[TD]53[/TD]
[TD]47[/TD]
[TD]0[/TD]
[TD]210[/TD]
[TD]300[/TD]
[TD]390[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE68[/TD]
[TD]RE68/04+ET093[/TD]
[TD]4[/TD]
[TD]82[/TD]
[TD]80[/TD]
[TD]76[/TD]
[TD]70[/TD]
[TD]62[/TD]
[TD]0[/TD]
[TD]210[/TD]
[TD]300[/TD]
[TD]390[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE65[/TD]
[TD]RE65/05 + ET093[/TD]
[TD]5[/TD]
[TD]98[/TD]
[TD]97[/TD]
[TD]96[/TD]
[TD]94[/TD]
[TD]91[/TD]
[TD]0[/TD]
[TD]150[/TD]
[TD]200[/TD]
[TD]250[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE65[/TD]
[TD]RE65/06 + ET112[/TD]
[TD]6[/TD]
[TD]118[/TD]
[TD]116[/TD]
[TD]114[/TD]
[TD]113[/TD]
[TD]110[/TD]
[TD]0[/TD]
[TD]150[/TD]
[TD]200[/TD]
[TD]250[/TD]
[TD]300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE70[/TD]
[TD]RE70/06 + ET150[/TD]
[TD]6[/TD]
[TD]114[/TD]
[TD]111[/TD]
[TD]110[/TD]
[TD]109[/TD]
[TD]103[/TD]
[TD]0[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RE70[/TD]
[TD]RE70/07 + ET187[/TD]
[TD]7[/TD]
[TD]133[/TD]
[TD]129[/TD]
[TD]128[/TD]
[TD]127[/TD]
[TD]120[/TD]
[TD]0[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]