I have sheet 1 with bill of materiel (product & material).
on 2nd sheet i have only material list with available stock(use in sheet 1 products).
i want separate cell on sheet 2 ,where i type/ select products and its show only material use in that product.