Excel Return Multiple Matches with Xlookup, Excel tips
In this video, we go over how to use 1 X-lookup formula, to return MULTIPLE columns of data at once. This is a perfect shortcut if you were planning to do multiple V-lookups, one at a time. This is the 2nd video in a series all about X-lookup! To see the 1st video going over X-lookup basics, start here - • Xlookup vs Vlookup in Excel, How to use X-...
For more free resources and spreadsheet tips, visit - https://timesavingtemplates.com/freer...
To see the variable compensation template used in this example - https://timesavingtemplates.com/produ...