Course Description

In a large worksheet, it is advantageous to be able to find specific data for display and/or use in calculations.  LOOKUP, VLOOKUP, and HLOOKUP are functions in Excel that can help accomplish this.  This half-day seminar will show you how to master these three functions – and produce amazing results.

See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."

Related Courses

Other Courses

Who Should Attend

This course is designed for experienced Excel users who are seeking to advance their data analysis capabilities by using Excel's LOOKUP, VLOOKUP, and HLOOKUP functions.

Attend and You Will Receive

Upon successful completion of this course, you will receive a certificate of completion from NC State University.


To ensure your success in this course, you should have experience working with Excel. You should already understand spreadsheet concepts and be comfortable creating basic worksheets. You can obtain this level of skill and knowledge by taking Excel Level 1.

Attend and You Will Learn / Expected Outcome

Expected Outcomes

Upon successful completion of this course, you will be able to use Excel's LOOKUP, VLOOKUP, and HLOOKUP functions to analyze your raw data.


Attend And You Will Learn

  • Using VLOOKUP with other functions
  • Shortcuts to use
  • Case studies
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.