Deemo,

You are correct. I can have several "deliverables" per order number and I need to make sure all are captured. That is why I need to augment the VLOOKUP with some kind of AND statement that checks both the order number and part number to make sure all elements are included on the Forecast tab.