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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Need formula to match production order to customer order
0
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.