Excel Lookups

excel_tip
Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them.

Class Price: $59

Training Class Goal

Students will learn how to write formulas for both H and V lookups.

PreRequisites

Should be comfortable writing formulas in Excel.

Topics Covered

  • Understanding the syntax of a Lookup Function in Excel
  • Vlookups
  • Hlookups
  • Lookups with a Range
  • Lookups with an exact match
  • Looking up item codes in a sheet to return descriptions
  • Using lookups to create a penalty or discount schedule
  • Using Lookups in conjunction with IF statements

Upcoming Classes

Excel Lookups
Feb 22 11:00 am - 12:00 pm Excel Lookups Webinar Excel Lookups Excel Lookups Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them. Class Price: $59 Training Class Goal Students... Mission Critical Systems 22-02-2019T11:00 22-02-2019T12:00 Active
Active 22-02-2019 Active 59.00 22-02-2019
Register Now