This booklet is short and simple so you can learn some of the most used VLOOKUP's techniques faster. It comes with an Excel file already loaded with formulas and data from where you can learn and practice.
The 10 exercises mimic real business scenarios and each exercise is a different VLOOKUP technique. In addition to the 10 exercises, this booklet includes a TRY IT section with 10 more exercises from where you can keep practicing. You'll find some tips on how to fix the most common VLOOKUPs errors.
You'll learn how to do a simple VLOOKUP, how to VLOOKUP from one tab to the other, from one Excel file to the other, how to validate reports and deal with #N/As or errors. You'll also learn how to create a KEY to support your VLOOKUP formulas when your data gets more complex, and how to use the IFERROR() function within your VLOOKUP for data readability.