Table of Contents

Using the EBook. 7

Overview of Lookup Functions. 8

LOOKUP Function. 9

Data Validation. 12

Review Questions – Section 1. 16

VLOOKUP Function. 18

Create a Range Name. 20

Review Questions – Section 2. 24

VLOOKUP With IFERROR. 25

VLOOKUP And WILDCARDS. 31

Review Questions – Section 3. 33

Combining VLOOKUPS. 34

VLOOKUP With Other Functions. 38

VLOOKUP Across Multiple Sheets. 39

Review Questions- Section 4. 44

Using VLOOKUP For Multiple Results. 45

VLOOKUP and ROW() and COLUMN(). 45

Drawback to VLOOKUP. 52

CHOOSE Function. 54

CHOOSE VS VLOOKUP. 55

VLOOKUP Searching In A Different Column For A Match. 55

CHOOSE And SUM... 60

HLOOKUP Function. 62

Review Questions – Section 5. 64

INDEX And MATCH.. 65

Review Questions – Section 6. 70

OFFSET Function. 71

INDIRECT Function. 79

HYPERLINK Function. 82

REVIEW ANSWERS/SOLUTIONS. 84

GLOSSARY. 87

INDEX. 88

CPE EXAM – Final Assessment. 90