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