EPISODE · Mar 13, 2014 · 54 MIN
CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you
from Chandoo.org Podcast - Become Awesome in Data Analytics · host Chandoo
In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions. What is in this session? In this session, we tackle one of the most important areas of Excel. The lookup functions. You will learn, Why lookup functions are necessary 5 Important lookup functions in Excel - VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX When & how to use each of these 5 functions? Extreme scenarios: What happens when the value you are looking up is not there? What if too many items match the lookup value? What if you have too many conditions in the lookup criteria? Using IFERROR function Re-cap of the new powers you acquired 4 Resources for you to learn lookup functions better The post CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
NOW PLAYING
CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you
No transcript for this episode yet
Similar Episodes
Mar 26, 2026 ·1m
Mar 19, 2026 ·34m
Feb 18, 2026 ·11m
Feb 11, 2026 ·45m