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