Similar authors to follow
See more recommendations
About Peter Globus
He has worked for over fifteen years using data analysis in the fields of retail, supply chain, and real estate. Peter also has an occasional blog where he posts about related topics at notadatascientist.net.
Customers Also Bought Items By
Become a Microsoft VLOOKUP Function Spreadsheet virtuoso!
If you want to master Excel then begin with formulas. VLOOKUP should be the first function you learn backwards and forwards. There are books and blogs that cover general information on this topic, but Become a VLOOKUP KnowItAll contains detailed explanations on why and how the nuts and bolts of Microsoft Excel VLOOKUP works. This is not a VLOOKUP for dummies, but for users looking to harness the full power and detail behind Microsoft Excel VLOOKUP.
Wait – but is it a boring, dry read then? No Way! Become a VLOOKUP KnowItAll contains a mildly humorous tone, uses analogies to drive points home, gives readers opportunity to think through examples, and even includes exercises at the end of each chapter. There are screenshots and a free downloadable companion file with examples along the way.
In this book you will:
- Learn the purpose of each VLOOKUP argument - lookup value, table array, column index, and range
- Explore multiple creative ways to pull information into these arguments
- Understand error messages, troubleshoot them, and learn how to prevent
- Experiment with advanced techniques to pull data together using VLOOKUP
- Answer review questions at the end of each chapter
Be a professional spreadsheet guru. Understand the details of the file and learn how to avoid errors. In the business world, Excel Worksheets are a standard document used for reporting and analysis. The VLOOKUP formula is frequently used in these reports.
For basic reference, do not buy a book. Seriously. Google VLOOKUP to get basic information on how it works. Don’t waste your money on VLOOKUP books for that. This book offers more depth on the subject.
Many Excel users grasp the gist of VLOOKUP. When you finish this book, you can confidently say you know it all.
Is this a beginners’ book? Yes and No - Someone with basic Excel skills should be able to grasp the concepts within this book. That said, the intended audience is for anyone looking for detailed explanations on what this function can do.
The point is, you can accomplish some amazing feats in Microsoft Excel with VLOOKUP! When you harness the power of VLOOKUP, you will find that manipulating data will become significantly easier to do.
Explore the depths of the VLOOKUP function to see what goes into each part.
VLOOKUP Lookup Value:
What goes into the Lookup Value?
What can and cannot be used?
What other formulas can one embed within the Lookup Value?
Also find detailed information on:
VLOOKUP Table Array, VLOOKUP Column Index, VLOOKUP Range, Absolute and Relative Values, VLOOKUP and MATCH
Learn more about what causes an
Excel VLOOKUP Error
What does it mean?
How do I avoid it?
Can I make it stop?
Become a VLOOKUP KnowItAll answers these questions and more. Preview it now!