### CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmThis video is a part of VLookup Week: http://vlookupweek.wordpress.comUnlike other lookup functions, CHOOSE lets you lookup "things" besides values: Text, Numbers, Formulas, Functions, Cell References, Ranges, Defined Names, Array Constants.Unlike other lookup functions, CHOOSE requires that you enter the "things" into the function individually.See these examples:1. Randomly CHOOSE names (where value is "text" (in quotes)) (min 2:00 )2. Use CHOOSE for Survey Results (text) (Choose rounds down number to integer) (min 3:13 )3. Use CHOOSE to select Quarters (select numbers) from Serial Dates (min 4:21 )4. Use CHOOSE to formula for Match Teacher template (min 6:32 )5. Use CHOOSE with Form Combo Box to select Average Formula (min 7:48 )6. Use CHOOSE to select function (min 11:43 )7. Use CHOOSE to select the correct MATCH function for an "OR" lookup situation (min 12:22 ) 8. Use CHOOSE to select Cell Reference (min 18:03 )9. Select Table for VLOOKUP with CHOOSE, where the values are ranges (min 19:05 )10. Select Table for VLOOKUP with CHOOSE, where the values are defined names (min 22:17 )11. Use CHOOSE to select array constant that tells MID function multiple starting points for text extraction, all in order to calculate the "Net Cost Equivalent" for a Series Discount. (min 26:05 )12. Use CHOOSE with Array constants entered into index_num argument to choose more than one thing at once: "mash" columns together to form a lookup table inside formula. (min 34:11 )

Length:
37:47