Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...