Randbetween range based on cell values on different sheet

Hello,

I would like to return a random value from sheet "Sales Profit" where Country is the criteria. I tried something with the MATCH function, but that didn't work out for me.
This is what I have so far (EU-version) :

=INDEX('Sales Profit'!B:B;RANDBETWEEN(1;COUNTA('Sales Profit'!B:B)))

In the attached example the random value for Bahrain would be somewhere in between 1-4, Belgium 5-71, etc.

Thanks!

Its not very clear what you want, perhaps
=RANDBETWEEN(MATCH(B2,'Sales Profit'!A:A,0),MATCH(B2,'Sales Profit'!A:A,0)+COUNTIF('Sales Profit'!A:A,'Random selection'!B2)-1

return the row of the first match
count the number of values that match
random between (first match, first match + number of matches -1) then subtract 1 to get to your references

uk version change the , for ;

Sorry I wasn't very clear, however your post helped me out to fix the formula. I wanted to return the value in column B of the Sales profit sheet (text).

This works for me:
=INDEX('Sales Profit'!R:R;RANDBETWEEN(MATCH(B2;'Sales Profit'!L:L;0);MATCH(B2;'Sales Profit'!L:L;0)+COUNTIF('Sales Profit'!L:L;'Random selection'!B2)-1))

Thanks a lot!

Also helpful, thank you!