VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP

Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
In this new workshop, learn everything you need to know about VLOOKUP.
Here are the topics:
1. VLOOKUP = V = Vertical
2. VLOOKUP Delivers a value to a cell: Extract
3. VLOOKUP #N/A and IFERROR or IF
4. VLOOKUP and Data Validation List
5. VLOOKUP and Data Validation List Box
6. VLOOKUP with Named Range
7. VLOOKUP as Formula Element
8. HLOOKUP = H = Horizontal
9. VLOOKUP Delivers a value to a cell: Approximate Match
10. VLOOKUP with table on different sheet
11. VLOOKUP with table in different workbook
12. Show Full Record: Numbers above column header
13. Show Full Record horizontally: COLUMNS Function
14. Show Full Record vertically: ROWS Function
15. Show Full Record: MATCH Functions
16. Two Lookup Values: Add join column as first column in table
17. Two Lookup Values: Join columns in formula and use CHOOSE function
18. Partial Text Lookup: LEFT and SEARCH Functions
19. Partial Text Lookup: MID Function
20. Partial Text Lookup: RIGHT Function
21. TRIM and VLOOKUP: Space in lookup value
22. TRIM and VLOOKUP: Space in 1st column of table
23. VLOOKUP with 3 lookup tables: CHOOSE Function
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula
26. VLOOKUP and Table feature for Dynamic ranges

IMPORTANT: You must bring a laptop (Mac or PC) having Microsoft Excel 2016 to this workshop. This classroom does not have individual workstations.