Excel Forum
Similar Content
CHOOSE Function in Excel
Tutorial: Return a value from a list of values. This is like a mini-lookup function that contains a...
Choose Random Values or Cells from a List in Excel
Tutorial: Formula that allows you to choose random text or number values from a list or range of cel...
Get the Day of Week from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Highline Excel Class 46: CHOOSE function 4 Examples


See 4 examples for the CHOOSE function:
1.Randomly CHOOSE names (where value is "text" (in quotes))
2.VLOOKUP with 3 three tables. Select Table for VLOOKUP with CHOOSE, where the value is a defined name (could be range or cell)
3.Use CHOOSE for Survey Results (Choose rounds down number to integer)
4.Use CHOOSE to choose function
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.