Find Closest Value in Array

This is a formula that is used to compare the market value of a particular job against the midpoints in a grade structure.  This spreadsheet looks at the market value and returns the midpoint that is closest.

As a quick reference, the formula is: 

=INDEX($A$2:$A$10,MATCH(MIN(ABS($A$2:$A$10-D2)),ABS($A$2:$A$10-D2),0),)

download sample spreadsheet