Hi How to filter on Column A (Excel 1) based on the parameter input from column D (Excel 2), Excel 1, and Excel 2 are blended using common values(Column C). Excel 1 with 1200 rows(grouped) and Excel 2 with 2700 rows.

How Can I use formula in the filter condition where the parameter value is searched, corresponding group name from the nearby column is taken as the filter value?