Good evening, I would like your help to find the date in column Au relative to the product of AS column with lot in AT column of Sheet2 and bring it back in the sheet 1 in column Q for the name in column G and lot in column N.
I tried with the formula
= IFERROR (INDEX (Sheet2! $ AU $ 2: $ AU $ 5000; SMALL (IF ((Sheet2! $ AU $ 2: $ AU $ 5,000 <> "") * (Sheet2! $ AS $ 2: $ AS $ 5,000 = G3) * (Sheet2! $ AT $ 2: $ AT $ 5,000 = N3); ROW (Sheet2! $ AT $ 2: $ AT $ 5000) -MIN (ROW (Sheet2! $ AT $ 2: $ AT $ 5000)) + 1) ; CONTA.SE ($ N $ 3: N3; N3))); "")
but it does not give me the desired result.
* In the attached file I applied the filter in the two sheets, and I would like the AU Sheet2 column dates were given in sheet 1 column Q ..
Thank you
Bookmarks