Help please

Copper Contributor
I have two worksheets. Let’s say A & B, on work sheet b there is a column with a list of products and beside it a column where you enter the qty of the product you want. On work sheet A I want the column where product description goes to automatically pull data from the list of products on worksheet b if that product has a number entered in the qty column beside it. I tried using the ifs function but I have too many products. Does anyone know of a way to do this?
Thanks heaps
6 Replies

@Aleisha2125 

Perhaps VLOOKUP or INDEX/MATCH. Could you submit small sample file to illustrate how data is organised?

 

 

Hi  @Sergei Baklan 

 

Thanks for replying I have attached a sample file for you to have a look at.

@Aleisha2125 

Here

image.png

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. 

Thanks @Sergei Baklan !!

 

This work perfectly :)

@Aleisha2125 , you are welcome

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 :)