Determine next level from a table
 

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

Determine next level from a table
 

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

Determine next level from a table
 

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