Problem description & analysis

Here is an Excel file Book1.xlsx:

We are trying to find the Notice values corresponding to multiple Product values in cell A6. Below is the desired result:

Solution & explanation

First, we load add-in ExcelRaq.xll, and then

Select cell B6 and enter the following formula: =esproc("=?1(?2.pos(?3.split@c())).concat@c()",B2:B4,A2:A4,A6) and press Enter to get results.

Q & A Collection

https://stackoverflow.com/questions/63557745/excel-how-to-find-all-rows-matching-elements-from-a-comma-separated-list-without