Find Multiple Matches with ONE XLOOKUP Formula!
The tutorial demonstrates how a single XLOOKUP formula can find multiple result values.
The XLOOKUP function is the improved version of VLOOKUP and HLOOKUP. XLOOKUP function is used when you need to find things in a table or a range by row. The difference between VLOOKUP and XLOOKUP is that XLOOKUP can search for a return value regardless of which side the return column is on. It can look for a return value left or right of the lookup value, while VLOOKUP could only look from left to right. Both functions support the exact and approximate matching. XLOOKUP function makes it easier to find multiple items based on a lookup value without changing the formula.
The tutorial will demonstrate how XLOOKUP can be used to return multiple items based on a lookup value without changing the formula even when result arrays are not next to each other.
► Subscribe for more Excel tutorials: https://bit.ly/3gsTNIt
#exceltips #exceltutorials #excelformac #datavisualization
Watch video Find Multiple Matches with ONE XLOOKUP Formula! online without registration, duration hours minute second in high quality. This video was added by user Data Scientist 02 August 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,80 once and liked it people.