Because the purchase values in Column C aren’t sorted, we’ll use [match_code] to specify the type of match. The default is 0 for find an exact match. Instead, we’ll use -1, which is Find an ...

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion.

XLOOKUP can also be used in conjunction with formulas such as SUM to retrieve certain items and add them up for a total value, which feels especially powerful when you're calculating separate values ...