Changing Conditional IF Values

[BrownTeddyBear]

Hi there,

Sorry. I know I asked about this before but I thought my explanation wasn't very clear so I'll try again.

I have two worksheets. One is called "Orders" and the other is "Invoice2".

On my "Orders" sheet I have a listed of product codes and ordered quantity. One column being ordered quantity and the other being product codes.
For instance it is like this:

Product Codes Ordered Quantity

TH1 5
AB3 0
JC5 10
LFK 11

On my "Invoice2" sheet I have a column for product codes and ordered quantity. Basically, I want the "Invoice2" sheet to reference the "Orders" sheet in relation to these columns. However, on the invoice I only want to display the product codes ordered and ordered quantity. For instance TH1 would be the first line and JC5 the second line. This is because AB3 is less than 0. So ever product code on the "Invoice2" sheet must be greater than 0 in ordered quantity on the "Orders" Sheet. This is what the invoice2 sheet would look like:

Product Codes Ordered Quantity

TH1 5
JC5 10

Does anybody have a suggestion on how to achieve this?

Thank you.

Kind regards,

Brown Teddy Bear