Close this search box.

The VLOOKUP book is ready, pick up your copy today & Become Awesome



the-vlookup-book-ebookHi folks,

What a night it has been. Unlike hi-fi product launches for a new perfume or car, my book launch did not have hot models or unlimited champagne. And yet, last 18 hours has been an intense and lovely experience. And finally,

My book is out.

You can purchase a copy thru Amazon or our website.

Go ahead and get your copy. I will wait…

Those of you looking for more info, read on.

Oh! Why should you bother reading this book?!?

The purpose of this book is to make you really good in answering any data lookup related question using Excel.

It captures various techniques, ideas and formula concepts that are necessary to write lookup formula for almost any situation. It is more of a “how-to” book than a theoretical book. Each chapter starts with a goal or a problem and we work thru various solutions to reach our end point. Along way you will be picking up some useful Excel functions, formula writing techniques and bad humor.

More than VLOOKUP or any other lookup formulas, I hope this book also enlightens you on how to think about your data problems. I believe that Excel is like a Lego kit. Creative, beautiful & inspirational stuff can only be made when you combine different pieces. If you just take a 2×2 block, you get nothing. Combine it with something else, and you just made progress. So I hope this book gives you some new building blocks that will enhance your Excel knowledge and make you even more awesome.

How to purchase the book

Simple. Just visit the vlookup book page and choose the option you want. We have below variations of the book.

eBook versions:

  • Kindle version, this can be read on Kindle device or app @ $9.99
  • PDF version, this can be read or printed as you wish @ $9.99

Video Book:

Apart from the ebook, I also have a ebook + video book combo option. This will give you 4 hours detailed video on all aspects of lookup formulas + PDF version of the book + example Excel file. This option also gives you access to 3 bonus videos on new lookup concepts like comparison of lists, handling duplicates and using Excel 2013 data model features. This is available for $29.99.

Get this from here.

Got the book? Share your review please…

If you have the book already, please take a minute to write a review for it on Amazon. This will help more people discover the power of Excel lookups and makes world a little more awesome 🙂

Click here to post your review.

Thank you & Enjoy

Thank you so much for your support and encouragement to Chandoo.org. Without you, I could not have written this book and published it. Go ahead and get a copy of the book. Enjoy it and become awesome in lookup formulas.


Share this tip with your colleagues

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

27 Responses to “The VLOOKUP book is ready, pick up your copy today & Become Awesome”

  1. Lohith says:

    Congratulations and Thank you Chandoo. I will order my copy today.

  2. Congrats on the book! I will be ordering a copy momentarily. I wanted to let you know the amazon link does not appear to be working.

  3. Sajan says:

    Congratulations Chandoo!

    Your post reminded me of "VLOOKUP week" from last year!

    Hope you plan a sequel to your book!

  4. Major Congratulations Chandoo !

    I am downloading the book now. What a great accomplishment. The link appears to be working fine now.

  5. Congratulations Chandoo!

    Keep up the good work. Expecting more awesome products from you.

  6. Kiran says:

    Congratulations Chandoo! Happy to see a this book from you! Just ordering now 🙂

  7. Congratulations Chandoo 🙂 Way to go..

  8. stansult says:

    Congrats on your book launch!

    One question though: why do you keep calling VLOOKUP formula?
    It’s Excel function: http://i.imgur.com/qbp2XGQ.png

    Formula (in Excel context) is the expression we type in the Formula Bar: http://i.imgur.com/20GhUlF.png

    So the function VLOOKUP can be part of the formula.

  9. zamapon says:

    Hello Mr Chandoo,
    Congratulations, I was d/l my copy today.
    Glad to read, so very useful and enlighten me.

    Bangkok, Thailand

  10. AMIRAM says:



  11. John says:

    Hi, Chandoo,
    I got my VLOOKUP book from Amazon yesterday and it looks like a great book! I'm especially impressed by the example file that goes with the book...extremely easy to follow, especially with the formulas shown right next to your examples. It makes it very easy to translate your examples into my real-world needs...thanks!

  12. Chandoo says:

    Thanks John, Zampon, Raghavan, Kiran, Ravi, Rick, Sajan & Lohith and countless others who purchased the book. I am very happy you like it 🙂

    @Stansult: It is just a old habit. When I say formula, I really mean either function or expression.

    • stansult says:

      Sure, that’s understandable. Just thought you might want to be more accurate with the terminology on the subject.

  13. Duncan Williamson says:

    I bought and read your book, including doing all of the homework tasks, within a few hours. I enjoyed it as you have a very engaging style, including your humorous interludes.

    Can I ask, though, that you proof read the book and have edition two done fairly quickly. I also think you shouldn't really be using so many merged cells when centre across selection is a much better alternative.

    Errors for the unwary, example, on page 31 you say the "The data is in table - Sales" but in the Excel file I downloaded it is called Sales2.

    I learned a few things from this book and I do recommend it.

    I bought the PDF version as I have tried to use Kindle versions of Excel books before and it can be difficult to match text and diagrams ... not your fault, Kindle formatting fault!

    Good work


    • Chandoo says:

      Thanks Duncan for the feedback. I have fixed several mistakes and updated the kindle book a day ago. I will be making few more corrections in the next few days and once it seems final I will work with Amazon so that you (and rest of the customers) can download newer version.

      If you bought PDF version, you will get free update as well 🙂

  14. […] The VLOOKUP book is ready, pick up your copy today & Become Awesome | Chandoo […]

  15. Matt Healy says:

    Bought the book in PDF format and had my first quick look; already have learned some useful tricks.

  16. Chus says:

    Congratssss on yor new book I am going to get a copy right away....keep it up and thanks for sharing ur knowledge 🙂 I will post my review in amazon once I devour it.

  17. Vrunda says:

    What is the indian price for ebook & combo version separately.?

  18. mike says:

    hi, Chandoo

    Great book. Very user friendly. Just want to know, are you going to post the answers for the homework questions on your book??

  19. Harish says:

    Chandoo, can you share the contents of this book please? Would like to know what is covered in this book. I am looking for a comprehensive book with lots of examples on text processing.

  20. Kerry says:

    Just getting started with the book and finally today used my first successful Index/ Match formula! I have read all your posts and tried it before but something never clicked, but your book finally helped me get it. I love Powerpivot and would prefer that to "Vlookup Hell" as you have accurately described it, but my company is slow to get me updated from Windows XP (that's right I said XP!) and Powerpivot is not working great on XP. So, long story short, I need to know more lookups!

  21. saket says:

    I have the vlookup book and I wanted to know where I can find solution to the homework you have provided in the excel

Leave a Reply