Lookup & Reference Cheat Sheets

 

 
Microsoft training delivered by certified trainers, and a microsoft partner training company
excel training
excel training
excel training
excel training
excel training
excel training
excel training
excel training

VLOOKUP Exact Match version

VLOOKUP Sorted List version

 

VLOOKUP dynamic column reference

 

VLOOKUP Multiple Values

 

VLOOKUP Multiple Criteria

 

VLOOKUP Multiple Columns

VLOOKUP Multiple Sheets

INDIRECT Function
excel training
excel training
excel training
excel training
excel training
excel training
Books
Home

VLOOKUP with CHOOSE

Lookup Return Multiple Values

HLOOKUP Exact Match and Sorted List

INDEX and MATCH

 

CHOOSE

OFFSET

 

Home

 

Here you’ll find some of the most common Excel functions explained in plain English, and applied to real life examples.

We steer clear of the techno babble you get in the Excel Function Wizard. The Excel Tutorials are grouped in line with the Function Library so they’re easy to find when you need them.

And when you’re ready to take your Excel skills to the next level check out our Excel training courses

 

Mike Barrett (MCT) Senior Training Advisor - The Mouse Training Company