I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products (Company/S.N./Quality). As:
And on a second spreadsheet (INVENTORY), I can see what we have in stock.
I would like to be able to see the quality of each of the products we have in stock. Like in this image:
I tried some kinds of IF and ArrayFormula... I understand it should be an easy problem, but I'm not a clever man.