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

YOU MIGHT ALSO LIKE

Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Working with tables in Excel 365 (2023)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Finding and analyzing data with formulas in Excel 365
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)
Course Excel with Python: Performing Advanced Operations
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Rating 4.6 of 538 users Rating 4.6 of 538 users (538)