Need formula to match production order to customer order

0

I need a formula to match production order to customer order if quantity available is <0. The quantity available column is a running total per Part ID

Answer
Discuss

Answers

0

This looks like homework and next time you'll need to at least try in order to get the answer, but this should do what you are looking for:

=IF(D3<0,VLOOKUP(A3,$A$12:$E$18,2,FALSE),"")

It's just a simple VLOOKUP function with an IF function or statement.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login