One way...

Try this array formula** :

=MIN(IF(A2:A10MAX(B2:B10),A2:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Code Numpty" wrote in message
...
I have tried doing this with INDEX and MATCH but can't get my head round
it.

I have 2 columns of data, containing blanks that are the result of an IF
formula.

40
100
100
200
400
600
800
1200
1600

The values will always be sorted from low to high. What I need to do is
take
the max value from column B (400 in this case) and return the next highest
value from column A (600).

Grateful for any pointers on this.