How to Use XLOOKUP as a Dynamic Area in the SUM Function
The tutorial will demonstrate how to use the XLOOKUP function as dynamic area.
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 support the exact and approximate matching.
The tutorial will demonstrate how to use XLOOKUP as dynamic ranges when summing up specific data.
► Subscribe for more Excel tutorials: https://bit.ly/3gsTNIt
#exceltips #exceltutorials #excelformac #datavisualization