Using VLOOKUP, MATCH, and INDEX

Using VLOOKUP, MATCH, and INDEX is a webinar that covers topics such as:

  • Understanding the importance of absolute references within many lookup functions
  • Learning the arguments in the VLOOKUP function
  • Simplifying multiple-field look-ups with concatenation (combining fields into a single cell)
  • VLOOKUP function in Excel for performing approximate matches
  • Using VLOOKUP to look up data from another workbook
  • Discovering how to use wildcards and multiple criteria within lookup formulas
  • Exploring why VLOOKUP sometimes returns #N/A instead of a desired result
  • Learning how VLOOKUP stops looking after it finds an initial match within a list
  • Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can`t find a match
  • Learning about the IFNA function available in Excel 2013 and later
  • Learning why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
  • Seeing how the HLOOKUP function enables you to perform horizontal matches
  • Perform dual lookups, allowing you to look across columns and down rows to cross-reference data you need
  • Using the MATCH function to find the position of an item on a list
  • View two worksheets from within the same workbook at the same time
  • Future-proof VLOOKUP by using Excel’s Table feature versus referencing static ranges

Using VLOOKUP, MATCH, and INDEX is intended for:

  • CEO`s / CFO`s / CTO`s
  • Business Owners
  • Accountants
  • Managers
  • Financial Consultants
  • CPA`s
  • Auditors
  • IT Professionals
  • Bookkeepers
  • Human Resource Personnel
  • Anybody with large amounts of Data
  • Marketers
  • Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

Past Events

   Using VLOOKUP, MATCH, and INDEX 2019  30 Apr 2019 (83857)

Find Similar Events by Category