Using VLOOKUP, MATCH, and INDEX 2019

Topics

• 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

Who should Attend

• 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