RANDARRAY (6,1,1,10) which returns a single list of six random numbers between 1 and 10. The INDEX () function uses those six random numbers to return names from the Table, Names.

Write the formula: Use =INDEX(range, MATCH(lookup_value, lookup_range, match_type)) to combine both functions. Practice with examples: Apply the formula to real datasets to understand its ...