Hi guys,

I've got 2 sheets, the first has a list of all our products and the user puts a 1 in column B if they want said product. The second sheet should then just bring in the lines that the user selected.

What I'm trying to get is some form of formula that will look in column B and when it equals 1 to then bring in column A, if B doesn't equal 1 then it skips on to the next row until it finds a 1.


I've attached an example to try to illistrate what I'm looking for.

Thanks in advance


example 30-04-13.xlsx