CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

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.