R

#### rockyboxboa

and column B is the qty.

TAB1

A B

1 Item Number Qty

2 500cc 0

3 1500cc 100

4 1500sp 0

5 3000cc 100

6 16000cc 100

These figures are pulled out of the database when you enter the purchase

order. On another tab of the spreadsheet is the packing list. I need a

formula that will reference the previous worksheet and ignore the 0 values.

So I need the packing list to look like this:

TAB2

A B

1 Item Number Qty

2 1500cc 100

3 3000cc 100

4 16000cc 100

5

6

Now I have been using the following formula in cell A2 that reads:

=if(tab1!B2>0,tab1!A2,if(tab1!B3>0,tab1!A3,if(tab1B4>0,tab1!A4,if(tab1!B5>0,tab1!A5,if(tab1!B6>0,tab1!A6,"")

Now this formula works great for cell A2 on tab 2. The problem arises for

cell A3. If I do the same formula as above, I come up with the same answer as

cell A2. I need to have the same formula AND somehow exclude the result from

cell A2.

In cell A4, I need to have the same formula and exclude the result from cell

A2 and A3.

And so on and so forth.

Anybody have any ideas how I could do this?