VLOOKUP Awesome Quick: From Your First Excel VLOOKUP to Becoming a VLOOKUP Guru
- 1h 1m
- Bill Jelen
- Tickling Keys
- 2012
VLOOKUP Awesome Quick is a book designed to get the reader up to speed with the VLOOKUP function in Excel. The book starts with the basics of "Explain a VLOOKUP in plain English", "How to Enter Your First VLOOKUP", how to troubleshoot VLOOKUP when you get all #N/A or a few #N/A errors. It covers steps to make VLOOKUP easier. You will learn real-life applications of VLOOKUP. The book moves on to advanced topics like moving beyond VLOOKUP to using INDEX and MATCH, Two-way VLOOKUP, Finding the last match. The last chapter includes examples of INDIRECT and OFFSET.
About the Author
Online, he’s known as Mr. Excel, but offline, he’s better known as Bill Jelen, a real-life Excel expert. Bill has over 18 years of spreadsheet experience. He has been doing Excel consulting since 1998 and it is now his full-time gig.
In this Book
-
The Basics: Building Your First VLOOKUP
-
Troubleshooting VLOOKUP: Solving What Can Go Wrong
-
Making VLOOKUP Easier
-
Using VLOOKUP to Solve Common Problems
-
Index and Match
-
Getting Fancy - Advanced Topics
-
Some Other Wild Functions
