Learn More
Free Tutorials
Explore my free Excel tutorials for easy tips on dashboards, charts, advanced formulas,
and quick productivity hacks.
This course has enabled me to finish jobs in
5-10% of the time due to my ability to process
Excel so far. It has also given me the confidence
Free Tutorials to better get around Excel.
- Mitchell Ryan
Courses Designed for Your Success
Discover the structured path to mastering Excel at your own pace with our bestselling
courses. Explore them now:
I'm using Excel often at work as a business architect. I was able to achieve
what I wanted a lot of the time but sometimes, I wasn't using the most
Enroll Now efficient way. Hence, I subscribed to the Black Belt package. There were a lot
of AH-HA moments! I'm now able to use Power Query and build good
looking dashboards more easily but it's only the first course out of a series
I'm taking with you.
I'm very excited about it!
- Christian Fiset
(Excel Black Belt Bundle)
VLOOKUP - Exact Match
Name Customer Profession Name Phone Number
Sid Keyboard Manager Moltisanti (312) 456 7890
Uhura Manager of Mischief Delfino (213) 321 6543
Moltisanti Director of Debugging Cooper (415) 800 1234
West (720) 446 7899
Sid (602) 803 5566
Peppone (504) 992 0512
Uhura (206) 900 9988
Profession
Director of Debugging
Pixel Pusher
Head of Procrastination
Head of Mouse Operations
Keyboard Manager
Code Wizard
Manager of Mischief
VLOOKUP - Exact Match: From Another Sheet
Name Phone Number
Moltisanti (312) 456 7890
Peppone (602) 803 5566
Uhura (206) 900 9988
Name Phone Number Profession
Moltisanti (312) 456 7890 Director of Debugging
Delfino (213) 321 6543 Pixel Pusher
Cooper (415) 800 1234 Head of Procrastination
Sid (504) 992 0512 Code Wizard
Peppone (602) 803 5566 Keyboard Manager
West (720) 446 7899 Head of Mouse Operations
Uhura (206) 900 9988 Manager of Mischief
VLOOKUP - Approximate Match: Looking Up Grades
Name Score Grade Range Score Grade
Moltisanti 26 E 0 - 54 0 E
Delfino 82 B 55 - 69 55 D
Cooper 99 A 70 - 79 70 C
Sid 16 E 80 - 89 80 B
Peppone 75 C 90 - 100 90 A
West 18 E
Uhura 89 B
VLOOKUP - Common Errors to Avoid
ID Customer Name Company ID Customer Name
US4556 Blend AT4731 WenCaL US
DE436 Not found US4556 Blend
AT4731 WenCaL US IT4706 Voltage
NL4093 Sleops ES4083 Inkly
NL4093 Sleops
DE4364 Kind Ape
PO4956 Hackrr
PL4761 Silvrr
