Hi, Mike

Very close to what I need ! one more criteria: if the value taken out has a
exactly match then return that value. if not then return the the next highest
value

Thanks Mike !

"Mike H" wrote:

Maybe

=INDEX(A1:A9,MATCH(365,A1:A9,1)+1)

Mike

"x6v87qe" wrote:

Hi, Group
I have tried doing this with INDEX and MATCH but without success.
I have 2 columns of data, A and B

A B

40 40
100 50
100 70
200 115
400 365
600 40
800 80
1200 985
1600 1150

What I need to do is take
the one value from column B (365 in this case) find the closest value in A
then return the next highest value from column A (600).

Grateful for any help !!