Index Match multiple criteria wont work, but nested IF's do-partially

Index Match bin numbers to materials.jpg

Hi,

Details are in the attachment, but basically what I'm trying to do is this:

I have a feed system that uses 19 bins. I have PI tags that tell me the material from each feeder, so it's easy to run a query that tells me what material is in each bin each day.

For the report I'm writing, I need to know what bin(s) each material is in. So the above table has the bin numbers as column headers but I want to translate that to materials as column headers for a specified date range.

No variation of Index/Match I've found on the net works, normal or array. I have partially succeeded using a formula of 19 nested if statements, but for materials that are in multiple bins, this will only return the first bin it finds, not all of them.

I really want to be able to automate this so anyone can use the sheet to generate a report, so any help anyone can offer will be greatly appreciated.