Using vlookup to find the next highest number in a range

Ur = 8
Um = 12       
3.6
7.2
12.0
24.0
36.0
72.5
123.0
145.0

My variable is Ur, and based on the Ur value Um is calculated. Um is the next highest number. For example Ur = 8, Um = 12. I tried using vlookup but it gives me 7.2. Do you have any ideas?
WTC_ServicesAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Try

=INDEX(A2:A9,MATCH(C2,A2:A9)+1)
0
 
Saqib Husain, SyedEngineerCommented:
Or use the UDF

Function nh(x, rng)
nh = WorksheetFunction.Index(rng, WorksheetFunction.Match(x, rng) + 1)
End Function
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.