This ebook is available for the following devices:

iPhone

iPad

Android

Kindle Fire

Windows

Mac

Sony Reader

Cool-er Reader

Nook

Kobo Reader

iRiver Story

About the author

Bill Jelen is the host of MrExcel.com, a Microsoft MVP, a frequent contributor to CFO Magazine. He is the author of 34 books about Microsoft Excel. Recent books include Excel 2010 In Depth, Pivot Table Data Crunching and LiveLessons Power Excel 2010.

VLOOKUP is a function in Excel that enables people to use Excel like a database, joining data on different worksheets. VLOOKUP Awesome Quick is an ehnanced eBook 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. Steps to make VLOOKUP easier. Real-life applicatons 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, finding the last item in a column, and more. The book includes 7 videos and 5 audio clips.