Ok so I verified the VB Code this morning and the formulas.
Looks like I have everything correct. I have a Module for the IFERROR Function and I changed all of the =_xlfn.IFERROR to =IFERROR.
It's still not working correctly. I did a sample of the data that I'm dealing with. Date for Item # 1543 exists in all 3 Warehouse, as well as 1542 exists in 2 of them.
See attached.
Bookmarks