Help please

Question

I have two worksheets. Let’s say A &amp; 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

sergeibaklan · Answer

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

aleisha2125 · Answer

&nbsp;&nbsp;Hi&nbsp;&nbsp;SergeiBaklan&nbsp;&nbsp;Thanks for replying I have attached a sample file for you to have a look at.

sergeibaklan · Answer

Aleisha2125&nbsp;
Here

in D5 you may enter
=IFERROR(
   INDEX('Worksheet B'!$C:$C,
      AGGREGATE(15,6,
         1/('Worksheet B'!$E$3:$E$100&lt;&gt;0)*ROW($A$3:$A$100),
         ROW()-ROW($D$4))
   ),
"")
and drag it down till empty cells appear.&nbsp;

aleisha2125 · Answer

Thanks&nbsp;SergeiBaklan&nbsp;!!&nbsp;This work perfectly 🙂

sergeibaklan · Answer

Aleisha2125&nbsp;, you are welcome

Forum Discussion

Help please

6 Replies

Resources