Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.
WHY SHOULD YOU ATTEND?
Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.
AREA COVERED
- Review of Vlookup
- See how the XLOOKUP function overcomes Vlookup's limitations in a side by side comparision
- See how XLOOKUp can lookup data in any direction
- Use XLOOKUP for 2 way lookups and built-in error messaging
- Apply XLOOKUP in exact and approximate match examples
- Index and Match functions
- Defined Names command
WHO WILL BENEFIT?
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
Go beyond Excel's Vlookup function to overcome its limitations. The focus in this course will be on using the next generation lookup function called Xlookup. See how you can use it to do lookups in any direction, do 2-way lookups, and embed error messages within it. Includes comparing Vlookup with Xlookup functions side by side. Also covers the Index, Match functions and the Defined Names command.
- Review of Vlookup
- See how the XLOOKUP function overcomes Vlookup's limitations in a side by side comparision
- See how XLOOKUp can lookup data in any direction
- Use XLOOKUP for 2 way lookups and built-in error messaging
- Apply XLOOKUP in exact and approximate match examples
- Index and Match functions
- Defined Names command
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals
