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

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

<colgroup><col span="2"><col><col span="11"></colgroup><tbody>
</tbody>