Random pick by some conditions

[Spikyd]

Good morning!

I have a list with some numbers (1.11 , 1.12, 1.13, 1.14, etc.) and a top 5 tabel
I want to pick some numbers from the list in the top 5 tabel by some conditions like... the numbers should be between 1.55 and 2.8 ... this is the first condition
and the second one, the product of the top 5 tabel numbers to be between (50 and 150 for example) ...
Is there any posibility to do this in excel ?
Have a nice day !

[tim201110]

=iferror(index(a:a,aggregate(14,6,row(a1:$a$301)/(match(a1:$a$301,$j$2:$k$2)=1)/(match(row(a1:$a$301),$j$4:$k$4)=1),$f4)),"")

[Spikyd]

Is good but sorry if i ask, is too complicated for me to understand the formula...
Can the numbers be randomly and not in order ?

[tim201110]

Can the numbers be randomly and not in order ?

which numbers?

[Spikyd]

From the Top 5 table.. they are in descending order 2.2, 2.19, 2.18, 2.17.. etc
I used a wrong word i guess, they are truly randomly.. i want to be mixed (1.57, 1.89, 3.14) something like this :D

[tim201110]

=index(row(indirect("1:"&$g$1)),aggregate(15,6,row(indirect("1:"&$g$1))/isna(match(row(indirect("1:"&$g$1)),$f$3:f3,)),randbetween(1,$g$1-rows($a$1:a1)+1)))