E
Esrei
I have 2 worksheets Data and Invent_Count.
In transit invent I have in A a list of all invertory codes and in row 1
order nr not shipped
Worksheet data is in database format with a column for Order_NR an a colmn
for Invent_Code
In Invent_Count!c2 I want to place a formula that would look in Data!A2:C500
match Invent_Count!A2 & Invent_Count!C1 and give me the quantity of a that
stock item on that order and 0 if not.
I am calculating remaining stock
Thank you
In transit invent I have in A a list of all invertory codes and in row 1
order nr not shipped
Worksheet data is in database format with a column for Order_NR an a colmn
for Invent_Code
In Invent_Count!c2 I want to place a formula that would look in Data!A2:C500
match Invent_Count!A2 & Invent_Count!C1 and give me the quantity of a that
stock item on that order and 0 if not.
I am calculating remaining stock
Thank you