Fill the range meeting certain criterias

[hsandeep]

Range D5:D17 generates numerical values. It does not generates zero or ‘’(null). D5:D17 is a non contiguous column.
Other input cells are C2; F2, G2 & H2

Output range G5:G17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest lower value’ of C2 in multiplication of F2.
Fill corresponding row of G with $G$2.

Output range H5:H17 to be filled with values from D meeting below criteria’s
Find the cell in D5:D17 which is ‘nearest higher value’ of C2 in multiplication of F2.
Fill corresponding row of H with $H$2.

How to accomplish?
Thanks in advance.

Book2.xlsx
	C	D	E	F	G	H
2	42229			100	1	2
3
4
5		42100			0	0
6		42200			1	0
7
8		42300			0	2
9
10		42600			0	0
11		42800			0	0
12
13		43000			0	0
14
15
16
17		43500			0	0
Sheet3

 

[Eric W]

Try:

Book1
	C	D	E	F	G	H
2	42229			100	1	2
3
4
5		42100			0	0
6		42200			1	0
7
8		42300			0	2
9
10		42600			0	0
11		42800			0	0
12
13		43000			0	0
14
15
16
17		43500			0	0
Sheet1

Cell Formulas
Range	Formula
G5:G17	G5	=IF(D5="","",IF(D5=AGGREGATE(14,6,$D$5:$D$17/($D$5:$D$17<$C$2)/($D$5:$D$17<>""),1),$G$2,0))
H5:H17	H5	=IF(D5="","",IF(D5=AGGREGATE(15,6,$D$5:$D$17/($D$5:$D$17>$C$2)/($D$5:$D$17<>""),1),$H$2,0))

 

[hsandeep]

Try:

Book1
	C	D	E	F	G	H
2	42229			100	1	2
3
4
5		42100			0	0
6		42200			1	0
7
8		42300			0	2
9
10		42600			0	0
11		42800			0	0
12
13		43000			0	0
14
15
16
17		43500			0	0
Sheet1

Cell Formulas
Range	Formula
G5:G17	G5	=IF(D5="","",IF(D5=AGGREGATE(14,6,$D$5:$D$17/($D$5:$D$17<$C$2)/($D$5:$D$17<>""),1),$G$2,0))
H5:H17	H5	=IF(D5="","",IF(D5=AGGREGATE(15,6,$D$5:$D$17/($D$5:$D$17>$C$2)/($D$5:$D$17<>""),1),$H$2,0))

Thanks Eric.. both formula meets my requirement. Thsanks for your efforts, time & willingness to help.
7 Cheers