original_name | match_name_0 | score_0 | match_index_0 | match_name_1 | score_1 | match_index_1 |
---|---|---|---|---|---|---|
AGI Partners, LLC | agi partners llc | 100 | 5273 | agi partners llc | 100 | 5273 |
AXA Investment Managers S.A. | axa investment managers sa | 100 | 17995 | axa investment managers sa | 100 | 17995 |
Aberdeen Asset Management PLC | aberdeen asset management inc | 100 | 2123 | aberdeen asset management plc esop | 100 | 2128 |
Acharya Capital | karya capital | 63.66124359 | 105080 | hara capital | 62.29887861 | 84903 |
I want to filter this range to return all values if the column name contains “match_name” and the original name matches a name in column A. The filter range will be different sizes, so I’ve also added an ifstatment to get rid of empty values
this is my formula:
=FILTER(S1:Y5, ISNUMBER(SEARCH("match_name", $S$1:$Y$1)) * ($S$1:S$5=A2) * (IF(S1:Y5<>"", 1, 0)))
however, no matter what I do – i keep getting an error. I’ve tried breaking out everything up until the filter and it contains the same number of rows and columns as the filter range.