I'm finding the Xlookup formula keeps on becoming a superpower of all lookups. In this tutorial I'll show you how to use an Xlookup twice to lookup multiple columns.
The new Xlookup formula is a brand new formula that can replace the use of Vlookup. It searches down or across to find the value you want and then returns a value within the return range. Take a look at my video to see it in action.