Excel Power Hour: How to use XLOOKUPS

This event is run in partnership with the Healthcare Financial Management Association

Description

NEW XLOOKUP Function Power Hour

XLOOKUP (in Office 365) is a NEW replacement for the VLOOKUP function. It is a flexible and versatile function that can be used in a wide variety of situations.

XLOOKUP can find values in vertical or horizontal ranges, can perform approximate and exact matches, and supports wildcards for partial matches.

•    First look at XLOOKUP
•    XLOOKUP to replace VLOOKUP and benefit.
•    XLOOKUP for Exact Matches
•    XLOOKUP for Nearest Matches
•    XLOOKUP to replace INDEX/MATCH functions.
•    XLOOKUP to Compare Tables
•    XLOOKUP to replace HLOOKUP
•    Using Wildcards