check a pair of cell with list of pairs google sheet code example

Example: check a pair of cell with list of pairs google sheet

//Will show A to E rows that have matching A,B pairs in Filter list
=filter(ToFilter!A:E, countif(Filter!A:A&Filter!B:B,   ToFilter!A:A&ToFilter!B:B))