In the 44th session of Chandoo.org podcast, let’s talk about failures.

What is in this session?
In this podcast,
- Book announcement about Dashboards for Excel
- Story of my first ever dashboard
- Important lessons – Requirement Analysis for dashboards
- Resources for creating awesome dashboards
- Podcasts
- Books
- Courses
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Resources to make awesome dashboards
Podcast episodes:
- Create awesome dashboards with this 10 step process
- Make better charts by optimizing Data to Ink ratio
- Rules for making legendary column charts
Books on Dashboards:
- Information dashboard design by Stephen Few
- Non-designers design book by Robin Williams
- Dashboards for Excel by Jordan & Chandoo
Courses:
- Excel School + Dashboards – Online classes from Chandoo
Excel School, is a comprehensive online course to help you become awesome in all aspects of data analysis, visualization, interactive workbooks, dashboard reporting and automation.

In this course, you will learn to:
- Analyze data using simple & advanced formulas in Excel
- Structure & process large volumes of data quickly using tables & pivot tables
- Present information using charts, interactive & dynamic charts and complex charts
- Create dashboards using 8 in-depth tutorials & case studies
- Make gorgeous workbooks using conditional formatting, color & font choices and more
- Develop workbooks faster: using my favorite tricks and productivity hacks
Please click here to know more about Excel School and enroll
Transcript of this session:
Download this podcast transcript [PDF]
Help our community & me learn more by sharing your mistakes
It’s your turn. Share the mistakes you made during data analysis, dashboard preparation or automation projects. Let’s all learn from these and become stronger.














6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@Damian.. Welcome to chandoo.org. Thanks for the comments.
Yes, you can use the same with Excel 2003 lists too.
@Tom.. You have seen future and its awesome.. isnt it?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.