Excel formula: Random value from list or table | Exceljet
To get a random value from a table or list in Excel, you can use the INDEX function with help from the RANDBETWEEN and ROWS functions. In the example shown, the formula in G7 is: Excel formula: Random value from list or table | Exceljet