Need to learn all about VLOOKUP? Microsoft Excel MVP, Mike \u201cexcelisfun\u201d Girvin, presents 15 amazing VLOOKUP examples, from the basics to advanced.
\nDownload Excel START File: https:\/\/ift.tt\/2p9IKeC
\nDownload Excel FINISHED File: https:\/\/ift.tt\/2OmxFBX<\/p>\n
In this video Learn all about VLOOKUP. Learn from Basics to Advanced. See 12 amazing examples that will help you become a VLLOKUP Excel Master! Video taught by Microsoft Excel MVP and Excel YouTuber, Mike Girvin.
\nTopics:
\n(00:06) Introduction
\n1. (01:32) VLOOKUP is everywhere
\n(04:24) The different between Exact Match & Approximate Match Lookup
\n2. (06:00) VLOOKUP to Lookup Product Price (Exact Match Lookup)
\n3. (12:25) VLOOKUP to Lookup Straight Commission Rate (Approximate Match Lookup)
\n4. (18:32) Data Validation List & VLOOKUP
\n5. (21:45) Copy VLOOKUP Down a Column. Learn about Relative and Absolute Cell References.
\n6. (27:00) Dynamic Lookup Table: Excel Table feature
\n7. (31:47) Dynamic Data Source: Use Power Query to import Lookup Table
\n8. (36:14) VLOOKUP to Lookup Variable Commission Rate (Approximate Match Lookup)
\n9. (41:00) VLOOKUP & MATCH Function for Two-Way Lookup (Lookup Employee Information)
\n10. (48:02) Fuzzy Lookup = Incomplete Lookup Value
\n11. (51:50) VLOOKUP & IFNA Functions to Avoid Errors
\n12. (53:05) Partial Text Lookup & Converting Text Number to Number
\n13. (56:28) Avoid Zeros from VLOOKUP to Empty Cells
\n14. (58:27) Multiple Table Lookup with VLOOKUP and INDIRECT Functions
\n15. (01:04:40) Two Lookup Values
\n(01:08:29)Summary<\/p>\n