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.
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.
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.
15 Responses
Align charts to grid by holding alt while moving them. Same goes when resizing them.
please how can i debug a cell hidden with formula becos right now i just got a job but my predecessor lock all formular and no handover note . please i need to rescue my self becos there is a report to submitt this weekend
Ralph, Google unlock excel without password. You’ll find some VBA that will unlock everything for you
I still use this code to remove internal passwords:
http://www.mcgimpsey.com/excel/removepwords.html
Also, clicking format painter twice will keep it selected for multiple uses. Small thing but easy to miss
Wow! That’s a very useful tip – thanks a ton.
Wow ! Amazing. I never thought this would be possible at all. *THUMBS-UP !
Thanks for this Chandoo – very useful and a good reminder – sometimes forget all the available tricks!
Ralph,
Yo can try the unlcok VBA codes, that are simple, or you can open another excel sheet and get the data from the locked one. In the new one, the data will be unloced and unformated.
#5 question
how do i un-bug then again. when i press F9 i get the value but what shortcut can i press to get back the formula? Now i only know to press enter and press excel undo but i am sure there is a faster way.
thank you!
Press ESC. This will exit the formula editing mode and reverts to original formula.
#4 – CTRL+ENTER is a nice trick but be aware that it creates an array of the selected cells so that you cannot insert/delete the rows of columns of the array or edit an individual formula in the selected cells.
I think you are talking about CTRL+SHIFT+ENTER which is used to enter array formulas. CTRL+ENTER simply fills all the selected cells with same contents that you have in active cell of selected range(Constant values or formula both, as the case maybe). Also for CTRL+ENTER, the selected cells may or may not be a continuous range. If works on both continuous and non-continuous selections.
You are correct Ajesh. I read it as CTRL+SHIFT+ENTER instead of CTRL+ENTER. Both work in Chandoo’s tip but obviously CTRL+ENTER would be the better one to use. Thank you.
Dear Chandoo,
I want to know if it is possible to do the same pivot table “User interaction hacks”
Thx
CL