Match Formula Issue

[johnsor1]

Hi:


In the attached I am trying to fill out the "Order" number in Column C. I need to match up the material based on the Material and Delivery Date matching. I have duplicate materials numbers, so I need to have an exact match where the material and date match to give me the "Order" number.

Column I, J, and K are my data fields I need to search against. I need to pull the correct order number into Column C from Column K based on matching information.

Thanks.