filmov
tv
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.
#exceltips #exceltutorials #excelformac #datavisualization
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.
#exceltips #exceltutorials #excelformac #datavisualization
0:12:51
0:14:13
0:03:18
0:06:55
0:06:51
0:04:56
0:10:15
0:01:26
0:30:05
0:01:00
0:16:38
0:00:45
0:05:18
0:10:22
0:04:47
0:01:14
0:01:03
0:00:29
0:00:53
0:05:01
0:04:18
0:19:18
0:04:44
0:16:28