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.

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 ...

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 ...