11 Reasons Why You Should Check Out The VLOOKUP Book From Chandoo.Org

11 Reasons Why You Should Check Out The VLOOKUP Book From Chandoo.Org

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

Vlookup_Name

REASON # 2 

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

 

true_vs_false

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

 

IFERROR_IFNA

REASON # 4

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

2_record_lookup_Find_Second_One

REASON # 5

You’ll Learn How to Use LOOKUP and HLOOKUP Formulas

HLOOKUP_LOOKUP

REASON # 6

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

 

tables_in_vlookup

REASON # 7

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

 

Wildcard Search

 

REASON # 8

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

 

GIF_VLOOKUP_RECORDING

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

Lookup_to_the_Left

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.

sumproduct_array

REASON # 11

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

 

Helper_Columns

 

 

 

Excel Custom Number Formatting: Turn your values into K (Thousands)

Excel Custom Number Formatting: Turn your values into K (Thousands)

Happy Monday everyone!  This is another very quick post about how you can use some of Excel’s awesome functionality.  In this post I want to show how to use Excel custom number formatting to format a range of numbers into thousands (k).  Simply follow the steps below and you’ll be right on your way.  If you have any questions, feel free to leave a comment. (more…)

Sumproduct Vs. Excel Pivot Tables: Which Method is Best for Calculating Highest Monthly Production Scrap Value

Sumproduct Vs. Excel Pivot Tables: Which Method is Best for Calculating Highest Monthly Production Scrap Value

Getting the answers to your most important business questions is imperative for achieving success.  Being able to find the answers to your questions can quickly give you insight into what business processes and procedures need to be fixed in order for you to lower your costs and maximize your returns.  In this post we look at using Excel Pivot Tables versus the SumProduct formula to calculate which month had the highest production scrap within a given year.  Being able to get this information can allow management to dig deeper into why a given month had such a high volume of scrap and help address issues that may have caused the spike. (more…)