Fill and search an array

I have data in an excel worksheet where there are several employee names and each employee has several assignments like A7, A8, A12, etc. More than one employee may have the same assignment and I�d like to create an array which would show the assignment and all the employees that have that assignment, I think that I would need a two-dimensional array to do that where the first dimension would be the assignment and the second dimension would be the employee name(s). Both parts of the array should be 1-based.

If the name of the array was Assignments then the first dimension should be something like "A7" and Assignments(1,1) should be something like "Frank" and Assignments(1,2) should be something like "Mary" because Frank and Mary are both assigned to A7. Using VBA, how would I do that? Later I would like to be able to find all the names for a given assignment.

Hi MartinLiss

Please see above yellow ribbon instructing how to upload a sample file...Explain with this data what you are wanting to achieve in output...