Posted on October 30th, 2013 in - 27 comments Hi 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. Go ahead and get your copy. I will wait Those of you looking for more info, read on.
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 and choose the option you want. We have below variations of the book.
EBook versions:., this can be read on Kindle device or app @ $9.99., 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. 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 🙂.
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. Enjoy it and become awesome in lookup formulas. 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.
Autotune 6 pirate bay water pump. 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 Duncan.
We have talked a lot about and other lookup formulas recently during. In this post I am giving away a free VLOOKUP formula cheat-sheet for our readers. This cheat-sheet is prepared by specifically for our readers. I hope you enjoy the one page help on VLOOKUP. More resources on VLOOKUP & Other Lookup Formulas:. more Thanks Cheater John Thanks to Ates, the person behind for preparing this beautiful VLOOKUP cheat sheet and sharing it with us.
Visit his site if you are looking for more such cheat sheets. If you enjoyed this cheat-sheet, please take a minute to say thanks to Cheater John.
Friends, readers & supporters of Chandoo.org, I am very glad to announce my newest book – the vlookup book to help you become awesome in answering any lookup related question. What is this book? These days, any kind of work involves understand data & answering questions. Whether you are a school teacher or drilling site manager, you are always answering questions like, “What is the GPA of Sam in Grade 6?”, “Who dug the hole number 6925?”. And how do we answer these questions?
Using Excel of course. And this is where the ubiquitous VLOOKUP formula comes in to picture. Along with few other formulas like MATCH, INDEX & SUMIFS, VLOOKUP can let you answer almost any data related question you have. And my latest book helps you do this better.
The vlookup book is a no-nonsense guide to demystifying VLOOKUP formula and its cousins, so that you can answer any question related to your data without wasting too much time. Comprehensive and easy to understand This is a book for everyone who uses Vlookup. Most of us think Oh.
I already know the function. But this book will open your eyes to some brilliant techniques which can be used across Excel. If you use Excel but have never used Vlookup, then you need this book desperately. Nitin Paranjape, Microsoft MVP Get your copy of the vlookup book. Combo Offer How this works? If you are buying from Amazon: Then your payments, delivery and receipts (invoice) are handled by Amazon website.
They will send the ebook to your kindle app or device in few minutes after purchase. Everything works like clockwork & magic. If you are buying from us: Your payments are handled by nice folks at gumroad. They are 100% secure and safe. As soon as you purchase, you will receive your payment receipt and a download link to the ebook or vbook. If you are buying the combo pack, keep in mind that it is heavy (350 MB), so give it sometime to download. If you have trouble downloading the file, email us at [email protected] for support.
What do customers say about this book? Read the testimonials. Solid introduction to lookup functionsThis books does a wonderful job of taking each of the lookup functions available in Excel, breaking them down to a simple, easy-to-understand level, and then showing many examples of how these functions work. Things I loved most: – Having an example workbook to follow along with.
We all learn better by actually doing the problem, and dealing with Excel is no exception. – Reference links embedded in book.
As you read through the chapters, there are lots of hyperlinks to articles that give additional information about different topics. This adds to the usefulness of this book as a sort of “roadmap” to learning about these functions. =) Chandoo knows that not everyone absolutely LOVES working with Excel, so injecting some humor into the reading helps break up what might otherwise by a dry subject, into a fun read. – Lucas Moraga Excellent Excel Resource Buy it. I’ve been a longtime student of Chandoo and his new book will not disappoint you.
There are other Excel books, but none will explain lookup functions to you in such simple and easy to understand format. If you are really serious about learning Excel (lookup functions make magic happen in your workbook), purchase the videos also. Chandoo has a very straight forward way of teaching in his videos. In addition, go to his website and check out the forums. He has amazing contributors that are quick to respond and help you learn Excel.
Why are you still reading this? Go buy the book!!!
Excel Vlookup Example Pdf
– Dana Von Scoy 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. – Duncan W Bought the book in PDF format and had my first quick look; already have learned some useful tricks. – Matt Healy 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 need.Thanks! – John Hi Purna, So glad that you have created this book for people like me who spend lot of time using Excel to conduct basic data mining using VLOOKUP function a lot. – Guru 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.