The following tables list the data of the products and salespersons that make the top 10 by sales in January and February:

Find out the data of products and salespersons that make the top 10 in both January & February.

=spl("=[E(?1),E(?2)].merge@oi()",Jan!B1:C11,Feb!B1:C11)

Find out the data of the products and salespersons that make the top 10 once or more.

=spl("=[E(?1),E(?2)].merge@ou()",Jan!B1:C11,Feb!B1:C11)

Find out the data of products and salespersons that make the top 10 in January but fail to make the top 10 in February:

=spl("=[E(?1),E(?2)].merge@od()",Jan!B1:C11,Feb!B1:C11)

Notes:
The merge()function without parameter means the whole row will be taken as the matching criterion, and the merge() function with parameter means the parameter value will be taken as the matching criterion.

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655257342992
https://c.scudata.com/article/1655342206166