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
---
"theone29opn" wrote:
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