Explanation
This formula relies on the helper table visible in the range B4:D10.
Column B contains the six numbers we want as a final result.
Column C contains the probability weight assigned to each number, entered as a percentage.
RAND generates a random value between zero and 1.
The third argument for MATCH, match throw in, is omitted.
*Values in the lookup range must be sorted in ascending order.
Random weighted text value
To return a random weighted text value (i.e.
For example, =RAND() will generate a number like 0.422245717.
RAND recalculates when a worksheet is opened or changed.
MATCH supports approximate and exact matching, andwildcards(* ?)
you’re able to use INDEX to retrieve individual values, or entire rows and columns.
The MATCH function is often used together with INDEX to provide row and column numbers….
