vlookup.co
Learn VLOOKUP HLOOKUP and INDEX MATCH In-depth

Excel has several lookup functions in its kitty, and I can certainly say VLOOKUP is a truly a great function. If you can master it, you could consider yourself to be an advanced Excel user. VLOOKUP is one of the extensively used functions for data analysis and data comparing. Along with this, we are looking into HLOOKUP function in this guide.

What is VLOOKUP?

Wildcards in VLOOKUP

Other VLOOKUP uses

HLOOKUP

Handling errors using IFERROR / ISERROR / ISBLANK / ISNA

VLOOKUP Combinations

INDEX MATCH

Common Problems and Errors in LOOKUPS

on Twitter or sign-up for my monthly newsletter: