The standard VLOOKUP function only finds the first matching value. To output all results, you need to use other methods.

The simplest way for Excel 365 or Google Sheets is the FILTER function. It returns the entire array of rows that meet the condition. For older versions, a combination of INDEX and MATCH works.

A common problem is errors in the syntax of complex formulas. To avoid confusion, it's helpful to understand the logic of the SUMIFS function in Excel, which handles counting by multiple criteria perfectly.

🔗 Source: excel.rf