Determine next level from a table

[theone29opn]

I have a table that has the following information. Let's say that in c5 a
result of 350 was calculated. What type of formula would I use showing that
the next level from the table is 400? If c5=480, the next level would be
500.

low high
a b c5=350
200 299
300 399
400 499
500 599
600 699
700 799
800 899
900 999
1,000 1,099

 

[Max]

In say, D5:
=IF(ISNA(MATCH(C5,A:A,0)),INDEX(A:A,MATCH(C5,A:A,1)+1),VLOOKUP(C5,A:A,1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik

 

[T. Valko]

You haven't said what should happen if there's an exact match. So, based on
your request for *the next level* :

=IF(OR(C5<A5,C5>=A13),"off scale",LOOKUP(C5,A5:A13)+100)