Basic Math 
Pre Algebra
Algebra I 
Algebra I
Algebra II 
Geometry 
Trigonometry 
Precalculus 
Math Analysis 
AP Calculus AB 
AP Calculus BC
AP Statistics
Gen. Statistics 
Gen. Statistics
Probability 
College Calculus: Level I
College Calculus: Level II 
Multivariable Calculus 
Linear Algebra 
Differential Equations 
General Chemistry 
Gen. Chemistry
AP Chemistry 
Biochemistry 
Organic Chemistry 
Organic Chemistry Lab 
Physical Chemistry 
Physics – High School (Theory & Application) 
AP Physics 1 & 2 
AP Physics C: Mechanics 
AP Physics C: Electricity & Magnetism 
AP Physics B
AP Physics C: Mechanics
AP Physics C: Electricity Magnetism
Life Science (Middle School)
Regular Biology
Anatomy & Physiology 
General Biology 
AP Biology 
AP Environmental Science
Microbiology
Molecular Biology 
Intro to Psychology
AP Psychology
AP US History
AP World History
HTML Training 
HTML 5
Intro to Ruby Programming 
Web Design & E-Commerce
Introduction to C++
Intermediate Level C++
CSS Intro
Java
AP CompSci: Intro to Java
JavaScript
Introduction to PHP 
Advanced PHP Training w/ mySQL 
C#
Visual Basic
XML Training
QuickBooks (How-To Guide) 
MATLAB
Excel Power Query
Adobe Dreamweaver CC
Adobe Dreamweaver CS6 
Adobe Photoshop CS6 
Photoshop Designs to Code
Edge Animate CC
jQuery Mobile
Adobe Illustrator CS6
Adobe Premiere Pro CS6
Adobe Premiere Elements 11
ColdFusion 9
ColdFusion 9: Application Framework
Fireworks CS6: Web Workflow
Adobe Photoshop Elements 11 
English Grammar
Advanced English Grammar
English Composition
Application Essays
AP English Language & Composition
AP English Literature & Composition
Shakespeare: Plays & Sonnets
Reading Comprehension
AP Spanish
AP Studio Art 2-D
Music Composition
Music Theory
Music History & Appreciation
Learn Piano for Beatmakers and Producers
Answer EngineTable of Contents
Section 1: Excel VLOOKUP |
|||||
|---|---|---|---|---|---|
| Menu Example with Excel Vlookup | 7:34 | ||||
| We use a Starbucks Menu to have fun with VLOOKUP | |||||
| Wildcard Search with Excel Vlookup | 9:22 | ||||
| Learn how to perform a Wildcard search with Excel Vlookup | |||||
| Looking to the Left with Excel Vlookup | 16:37 | ||||
| You can also look to the left with Excel Vlookup and overcome Vlookup's limitation | |||||
| 2-Way Lookup | 13:38 | ||||
| Perform a 2-way Lookup with Vlookup | |||||
| Comparing Lists with Excel Vlookup | 3:20 | ||||
| See how to compare different lists with Vlookup | |||||
| Vlookup Tips and Tricks | 14:26 | ||||
| More Vlookup tips and tricks | |||||
Master Microsoft Excel VLOOKUP Formula and you will be able to:
- Understand the essence of Excel Vlookup, with advanced examples!
- See how these are used in real life examples!
After this class you will learn about:
- Basic Excel Vlookup
- How to compare lists
- Overcoming Vlookup's limitation of looking to the left
- Wildcard searching in Vlookup
- 2-Way lookups
- And more Vlookup tips and tricks!
Bryan is a best-selling book author of the 101 Excel Series paperback books and a Microsoft Certified Systems Engineer with IT experience of more than 10 years.
Courses Bryan is focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping students in whatever means possible, whether it be reaching them via courses or by books.
