Oct 14, 2015. Ray Blake, GR Business Process Solutions Page 1 Excel lookup functions explained Using VLOOKUP, HLOOKUP, INDEX and MATCH in Excel to interrogate data tables. Friends, readers & supporters of Chandoo, I am very glad to announce my newest book – the vlookup book to help you become. Editorial Reviews. ***** 'Chandoo does a great job with this topic - makes it light, fun,creative, and useful. A very 'human' treatment, with a lot of 'why's'explained. Reading this book is like having a question and answersession with a patient and friendly Excel master.' Rob Collie, Author, CEO, Microsoft MVP *****. Dec 20, 2013. This is the first book to cover regular pivot tables, Power Pivot, Power View and Power Map. Excel 2013 Building Data Models with Power Pivot – Alberto Ferrari, Marco Russo; The VLOOKUP Book – Chandoo; Ctrl+shift+enter: Mastering Excel Array Formulas – Mike ExcelIsFun Girvin; PDF Verson from Holy. Jun 19, 2009. If you want to sell this book or use it for commercial purposes, please. Chandoo, Pointy Haired Dilbert. Complete the Formula: =VLOOKUP(A2+0,Haystack!$A$2:$C$12,2,0). Catapult your skills and productivity with Excel Tips. Get a career.

About Chandoo.org At, my aim is to make you awesome in Excel. I do this by sharing whatever little I learn everyday. Our community has an open mind. We are eager to learn and share.

We all constantly teach each other new tricks and ideas using comments and forum posts. I am glad to know that you are here and want to be a part of us. I invite you to.

Every week I send 1 email with an excel tip or charting tutorial or useful material on VBA, Power BI, analytics to help you become awesome in MS Excel. Also check out to know how we can help you better.

I have launched Chandoo.org in year 2004. After 3 years of personal rants and chatter, I shifted the focus of site to Microsoft Excel, primarily to share new ideas and discuss about the problems I am working on.

Soon, the site gathered momentum and today it is a massive part of my life. We get 1,150,000 monthly views with readers from all over the world. There are ~125,000 members reading this blog through feed readers & email. The blog has been featured on Major newspapers, few books, LifeHacker, MSN, BNet, Technet and Delicious. It made me a better person and communicator.

I am able to connect with a wide part of the world and exchange ideas freely. All thanks to this little site.

John Bannon Dear Mr Fantasy Crosby. You can support this site by, • Joining one of my training programs –,. • Getting a copy of my books – &.

My products are well received by our members. You can try one of them and become even more awesome. About Me: Chandoo I am your CEO here, Chief Excel Officer. My full name is Purna Duggirala. Chandoo is my nick name and I used it as my domain name too. I have an MBA from and Computer Science degree from. I am passionate about Data Analytics and Visualization and this blog is my platform for sharing what I learn about Microsoft Excel and new ways of presenting data.