Using VLOOKUP, MATCH, and INDEX 2019

  • 30 Apr 2019
  • Webinar

Description

Using VLOOKUP, MATCH, and INDEX 2019 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 2019 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

Important

Please, check "Using VLOOKUP, MATCH, and INDEX" official website for possible changes, before making any traveling arrangements

Event Categories

Business: Finance, Management
Health & Medicine: Healthcare
Technology: Software & Applications

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions