JavaScript is disabled in your browser. Please enable JavaScript or upgrade to a JavaScript-capable browser to properly view this site. Thank you.

Monterey County Office of Education

Leadership, Support and Service to Prepare All Students for Success

Dr. Nancy Kotowski, County Superintendent of Schools

Course Description

In this shorter Excel training, we explore the usefulness of the Excel VLOOKUP and HLOOKUP functions.

Prerequisite: Excel 101 or basic understanding of functions and formulas in Excel.

Download Practice Workbook Here

Resources

Documentation for the lookup() function

Documentation for the vLookup() function 

Documentation for the hLookup() function

vLookup Video Tutorial

Contacts

Kudos Korner