Two-Way Nested XLOOKUP
As we’ve discussed in a prior lesson, XLOOKUP is a game changer – replacing VLOOKUP and HLOOKUP and eliminating many use cases where more complicated INDEX MATCH functions needed to be used.
In this lesson, you will learn about how XLOOKUP can be used to replace INDEX MATCH when you need Excel to take two user defined inputs.
