Quote Originally Posted by Glenn Kennedy View Post
Dates. They were changed to first of each month and then formatted to look like month names.
=IFERROR(INDEX(Sheet1!$I$2:$I$1588,MATCH(1,[/COLOR]INDEX((MONTH(Sheet2!C$2)=MONTH(Sheet1!$C$2:$C$1588))*(YEAR(Sheet2!C$2)=YEAR(Sheet1!$C$2:$C$1588))*(Sheet2!$A3=Sheet1!$A$2:$A$1588),0),0)),"")

Red, when the following conditions are met (1=TRUE)
Orange: the order month matches the month of the dates in row 2 AND WHEN
Cyan: the order year matches the yearof the dates in row 2 AND WHEN
Green: the part numbers correspond the return
Blue: the prices
Yellow: this bit converts the formula from a resource-heavty array formula to one that's a bit faster.
Black: if you return an error, then put a blank.



You're welcome.


If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Awesome

Thank you very much !!