Event box

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

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

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

This workshop is offered at 9am and 1pm today on S Campus
This workshop is offered Aug 18, 9am and 1 PM on N Campus
This workshop is offered Aug 23, 9am and 1 PM on N Campus

Date:
Friday, August 18, 2017
Time:
9:00am - 12:00pm
Location:
109 Lockwood
Campus:
North Campus
Categories:
Workshops
Registration has closed.

Event Organizer

James Gordon

More events like this...