The random values are in A2:A6
The Min values in B2:B6 (Max values not needed)
This formula =INDEX($D$2:$D$6,MATCH(A2,$B$2:$B$5,1))
returns the required 60
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Vitalie Ciobanu" <aisberg@rau.ro> wrote in message
news:eEBosT4SGHA.5736@TK2MSFTNGP10.phx.gbl...
> It seems that I can't figure it out for myself and need some help.
> For example I have a random number from 0 to 1:
> 0.10
> 0.11
> 0.24
> 0.08
> 0.14
>
> I also have two columns with interval numbers (min and max):
> min max
> 0.00 0.01
> 0.01 0.05
> 0.05 0.14
> 0.14 0.28
>
> And I have one column more with simple numbers:
> 20
> 40
> 60
> 80
> 100
>
> Now what I need. If I will take the first random number (0.10), it matches
> the third interval (0.05-0.14) and after this I have to look for the
> number that corresponds to this interval, in my case it is 60.
> I can't figure the formula that looks in what interval that matches the
> random number. Can someone help me with a hint or with a formula?
> Thank you!
> --
> Name: Vitalie Ciobanu
> Nickname: AISBERG
> Homepage: http://aisberg.rau.ro
>
>