VBA to Return Row and Column cell info based on number range.

[Ztcollins]

Row 1 has spring data from 500-10000 @ intervals of 25 IE 500, 525, 550, 575, etc starting at F1
Column E has Shock data that goes from 100-10000 @ intervals of 100 (IE 100, 200, 300, 400) Starting @ E2.

C5 is a cell were a number value is entered.

I want to make a executable search via once that number is entered to search the range of F2:NV101 and have it return the values of each Row 1 and Column E combination that is a match +/- 10 from the value in cell c5.

I want the results of the ROW to enter into Column A starting at A9 and the results of Column E to enter into Column B starting at B9with the cell value in C9. (IE if the number was exactly 420 then the results would show N6=700 in A9, 600 in B9, 420 in C9

Effectively this will give me every spring and shock combination that will match the number entered plus or minus 10 each way.
Refer to image below. Also the array has formulas.

Any and all help is appreciated and I am extremely thank full for it all.

 

[jasonb75]

Something like this maybe?

Book1
	A	B	C
5		Target	420
6
7
8	Row	Column	Cell
9	500	675	413.75
10	600	500	419
11	500	700	420
12	600	525	425.25
13	500	725	426.25
14
Sheet1

Cell Formulas
Range	Formula
A9:A14	A9	=IF(C9="","",AGGREGATE(15,6,$E$2:$E$39/($F$2:$S$39=C9),COUNTIF(C$9:C9,C9)))
B9:B14	B9	=IF(C9="","",LOOKUP(C9,INDEX($F$2:$S$39,MATCH(A9,$E$2:$E$39),0),$F$1:$S$1))
C9:C14	C9	=IF(ROWS(C$9:C9)>COUNTIFS($F$2:$S$39,">="&$C$5-10,$F$2:$S$39,"<="&$C$5+10),"",AGGREGATE(15,6,$F$2:$S$39/($F$2:$S$39>=$C$5-10),ROWS(C$9:C9)))

 

[Ztcollins]

Thanks work beautifully