Gents,
I hope someone can help with the attached database. I've nearly sorted it for what I want it t do apart from one thing. That one thing being is that when a part number is in various DEL SEQUENCE,STOCKROOMS and MAX LEVELS I want them all to appear instead of just the first option. For example part number 1015597 has 5 DEL SEQUENCES so I would want ALL 5 to appear in cell F10.
Hope you can understand.
laura.zip