Aug 21 2019 02:55 AM
Aug 21 2019 03:42 AM
Perhaps VLOOKUP or INDEX/MATCH. Could you submit small sample file to illustrate how data is organised?
Aug 21 2019 04:31 PM
Aug 22 2019 03:11 PM
Here
in D5 you may enter
=IFERROR(
INDEX('Worksheet B'!$C:$C,
AGGREGATE(15,6,
1/('Worksheet B'!$E$3:$E$100<>0)*ROW($A$3:$A$100),
ROW()-ROW($D$4))
),
"")
and drag it down till empty cells appear.
Apr 08 2020 07:31 PM
Hi @Sergei Baklan again!
Thanks so much for your help last time, I am now wanting it to only bring through description etc from worksheet B to worksheet A if in worksheet B the Qty is above 0 and if the Type column has machine under it. Is there a way to add this to the formula? I have added workbook with updated work sheet B.
Thanks Aleisha :)