Completed
17. Two Lookup Values: Join columns in formula and use CHOOSE function min
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel VLOOKUP Function - All You Need to Know
Automatically move to the next video in the Classroom when playback concludes
- 1 2. Why so common? Because everyone needs to look stuff up min
- 2 3. VLOOKUP Delivers a value to a cell: Extract Match min
- 3 4. VLOOKUP #N/A and IFERROR or IF min
- 4 5. VLOOKUP and Data Validation min
- 5 6. VLOOKUP with Named Range min
- 6 7. VLOOKUP as Formula Element min
- 7 8. HLOOKUP = H = Horizontal min
- 8 9. VLOOKUP Delivers a value to a cell: Approximate Match min
- 9 10. VLOOKUP with table on different sheet min
- 10 11. VLOOKUP with table in different workbook min
- 11 12. Show Full Record: Numbers above column header min
- 12 13. Show Full Record horizontally: COLUMNS Function min
- 13 14. Show Full Record vertically: ROWS Function min
- 14 15. Show Full Record: MATCH Functions min
- 15 16. Two Lookup Values: Add join column as first column in table min
- 16 17. Two Lookup Values: Join columns in formula and use CHOOSE function min
- 17 18. Partial Text Lookup: LEFT and SEARCH Functions min
- 18 19. Partial Text Lookup: MID Function min
- 19 20. Partial Text Lookup: RIGHT Function min
- 20 21. TRIM and VLOOKUP: Space in lookup value min
- 21 22. TRIM and VLOOKUP: Space in 1st column of table min
- 22 23. VLOOKUP with 3 lookup tables: CHOOSE Function min
- 23 24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH min
- 24 25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula min
- 25 26. VLOOKUP and Table feature for Dynamic ranges min
