How to get in which range a value lies out of multiple ranges

[liamcal23]

I have a value e.g 48
There are multiple ranges, and each range will correspond to a specific amount, example below:
11 to 20 --> 15
21 to 30 --> 25
31 to 40 --> 35
41 to 50 --> 45

I want to search for the value 45, so i need to check the multiple ranges to get that specific value on the right-hand side.
So if my value is 48, i want to get 45, likewise if the value is 12 then i want to get back 15.

Is that possible in excel?
Thank you!

 

[mikerickson]

If you put this in A1:C4

11 20 15
21 30 25
31 40 35
41 50 45

Then either
=LOOKUP(48, A1:A4, C1:C4)
or
=VLOOKUP(48, A1:C4, 3)

will return what you want

 

[liamcal23]

If you put this in A1:C4

11 20 15
21 30 25
31 40 35
41 50 45

Then either
=LOOKUP(48, A1:A4, C1:C4)
or
=VLOOKUP(48, A1:C4, 3)

will return what you want

Thank you, how about this:
What if i have the ranges within the same cells as specified?
11 - 20 15
21 - 30 25
31 - 40 35

The range themselves should be in the same cell separated by a dash (-), but the value to retrieve will still be in a cell of its own.
Is that doable?

 

[mikerickson]

Its doable with VBA.
If you don't know VBA, the formula approach (with one piece of data per cell) is the only way.