Mastering VLOOKUP

Learn how to really harness the power of VLOOKUP.  Go beyond the basics to get the most from this simple, but powerful function.

• • How to use VLOOKUP

• • VLOOKUP: What does the True/False statement do?

• • VLOOKUP: How to calculate faster

• • How to VLOOKUP to the left

• • VLOOKUP: Change the column number automatically

• • VLOOKUP with multiple criteria

• • Using wildcards with VLOOKUP

• • How to use VLOOKUP with columns and rows

• • Automatically expand the VLOOKUP data range

• • VLOOKUP: Lookup the nth item (without helper columns)

• • VLOOKUP: List all the matching items

• Advanced VLOOKUP Cheat Sheet

Other VLOOKUP Resources

• • The Last Guide to VLOOKUP You’ll Ever Need – Spreadsheeto

• How to do a VLOOKUP – Deskbright

Save

Save

Save

Save

Save