Explanation
This formula depends on two helper columns.
The firsthelper columnholds random values created with the RAND() function.
The formula in C5, copied down is:
The RAND function generates a random value at each row.
Note: RAND is avolatile functionand will generate new values with each worksheet change.
The second helper column holds the numbers used to sort data, generated with a formula.
The formula in D5 is:
Seethis pagefor an explanation of this formula.
This increments the lookup value, starting at 1 and continuing to 7.
MATCH then returns the position of the lookup value in the list.
The position is fed to INDEX as the row number, and INDEX retrieves the name at that position.
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
