I recently purchased a copy of Chandoo’s The VLOOKUP Book and realized that it was the first piece of material that I had read that covered pretty much all of the bases when  it came to the Vlookup formula and other lookup formulas in general.  Because I was able to learn something from this book I figured you may be able to benefit from purchasing the book.  Since I believe in Chandoo’s products and what he is doing, I decided to become an affiliate (the links in this post are affiliate links) and to provide you with some insight as to whether or not it may be something that you are interested in.  I will say that although the book is not perfectly written, it does a great job at showing all of the available options that you can use to run lookup formulas in Excel.

My hope in this post is to provide you with an overview on what this book has to offer.  Let’s get started with our 11 reasons and if you have any questions about the book or about the Vlookup formula in general, please feel free to leave any comments or to email me at brad@bradedgar.com.

By the way please be patient with the page slider below, it does take a little bit of time to load.

 

CHECK OUT THE VLOOKUP BOOK

REASON # 1 

You’ll Learn How to use Vlookup to Lookup a Value and Find Corresponding Information About that Value

REASON # 2 

You’ll Learn What the True vs. False Portion of the Vlookup Statement Truly Means and How To Use it

 

REASON # 3

You’ll Learn How to Use the IFERROR and IFNA Formulas with Vlookup to Display Any Value you Please If Your Formula Doesn’t Not Find a Match

 

REASON # 4

You’ll Learn How to Find the Second Item in a Lookup List When there Are Multiple Items

REASON # 5

You’ll Learn How to Use LOOKUP and HLOOKUP Formulas

REASON # 6

You’ll Learn the Benefits and How to Use Excel Tables with the VLOOKUP Formula – This Will Save You Time and Effort

 

REASON # 7

You’ll Learn How to Use Wildcards (abbreviated queries) with the Vlookup Formula Using *

 

 

REASON # 8

You’ll Learn How to Use Vlookup with Data Validation Lists, Name Ranges, Tables To Build Slick Dashboards

 

REASON # 9

You’ll Learn How to Preform Lookup Formulas When the Data That you Are Looking for is to the Left of Your Lookup Column

REASON # 10

You’ll Learn How to do Lookups Based on Multiple Conditions By using Formulas like SUMIF, SUMPRODUCT, INDEX MATCH, AND SUM and you Will Also Learn the Best Method.

REASON # 11

You’ll Learn How to Use Helper Columns with Vlookup to Find the Results You Are Looking For.