# Lookup Next Highest Value

Dec 2, 2008I have an excel work book that has distances in column A from A2:A10 like so:

ABCD

15013401400

240

3900

4800

5600

61400

71200

81100

91150

101600

I would like to compare the value inputed into cell C2 against the distances and return the exact match or next highest distance to D2 if there is no exact match.

i.e. If 1340 is put in Cell C2 I would like excel to return 1400 to cell D2 as 1400 is next highest distance from 1340.

Here is the kicker, the distances cannot be sorted and I would prefer not to use VBA but I will if i have to.