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

Find out the sales data of the products that make the top 10 in both January and February (the ranking and sales in January are required only):

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

Find out the sales data of products that make the top 10 once or more (the ranking and sales that appear for the first time are required only):

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

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

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

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655170519527
https://c.scudata.com/article/1655257446201