try this..

Formula: copy to clipboard
=RANDBETWEEN(VLOOKUP(B$2,$F$2:$H$5,2,0)*100,VLOOKUP(B$2,$F$2:$H$5,3,0)*100)/100