Case Sensitive Lookups
We all know that VLOOKUP (and its cousins MATCH, HLOOKUP and LOOKUP) are great for finding information you want. But they are helpless when you want to do a case-sensitive lookup.
So how do we write case sensitive VLOOKUP formulas?
Simple. We can use EXACT formula.
Weekend poll: Formulas or Pivot Tables?
Time for a quick weekend poll. What is your favorite tool for data analysis?
- Formulas
- Pivot Tables
- Or both
Post your choice in the comments. Also mention the number of years Excel experience you have.
For ex, my answer is: Both (10 years)
Book Announcement: Dashboards for Excel is launching on 15th September
Dashboards for Excel – what is it?
As the name suggests this book is a handy guide for anyone preparing dashboards, management reports and business intelligence workbooks using Excel. The key benefits are,
- Learn the visualization tools, charts, tables, and graphs important to management.
- Understand what management doesn’t want to see in a report
- Turn around dashboards faster and cheaper than ever before
- Understand the key role dashboards play in an organization
- Analyze real-world dashboards to apply important features to your own organization
- Utilize understated, but powerful, Excel formulas and VBA code
- Avoid common pitfalls in Excel development and dashboard creation
- Get started with the Excel data model, PowerPivot, and Power Query
As you can see, this is an advanced Excel book with lots of examples, case studies and practical tips.
Thank you for making Awesome August a success
Wow, what a month it has been. In August 2015, I announced Awesome August, an Excel festival. I published 31 articles, one for each day of August to make you awesome in your work. We had 3 podcasts, 11 videos, 17 articles and 238 comments in August. This content is consumed by more than 50,000 people from all over the world (3% of site traffic visited Awesome August pages). There were lots of emails, tweets and facebook posts telling me how you are enjoying Awesome August.
Thank you so much for taking time to learn from Chandoo.org and making Awesome August a success.
I made a short (5 mins) video to share the journey and to say thanks to you personally. Please watch it below.