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

Download Start workbook: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUPWEEKVideo05-START.xlsx
Download Finished workbook: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/VLOOKUPWEEKVideo06-Finished.xlsx

This video is a part of VLookup Week: http://vlookupweek.wordpress.com
Unlike 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 )

Видео CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5) канала excelisfun