Index matched array with duplicated matches, help needed!

[hbuzz]

I’m trying to perform an index match however I have repeated match results. Attached is a workbook. On worksheet Schedule Table is a list of works orders. It is column E product. I would like to perform a match against column B against the “Where Used” sheet column C but only when “Product Code” in the where used sheet matches column E of the “Scheduled Table”. The purpose of this eventually is to see stock requirements and usages.

I believe I need and index matched array but I’m really struggling with this and any help or ideas would be appreciated. Please note there are component codes which in some cases are the end product code.

Attached is my workbook.

Thanks!

[dflak]

Let me see if I can unravel this in my mind. You want to match Schedule Table[Column B] against Where Used [component Code] and Schedule Table [product code] against Where Used[Product Code]. So two records are equal when both matches are true.

Then what do you want to do with these matches? Do you want to get Assembly Warehouse by quantity by date?

[hbuzz]

Hello again Dflak,

Thank you for your offer of assistance. I've returned to this today thread today and previously solved it by putting the data into a pivot table with product and component in row/column and performing an index,match,match.

Thank you again and I hope you're well.