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

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

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)

--
Biff
Microsoft Excel MVP


"theone29opn" wrote in message
...
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