TO DonkeyOte: Thank you so much! And yes, the data in the "NAMES" column are unique & distinct to the "DEPT" column.

I didn't considered adding another column to generate intermediary criteria with which to solve my main issue. I just kept thinking:

A. Primary data set = dept name;
B. Secondary data set = recipient name;
C. Secondary set = subset of primary set.

and trying to fit all that together into one neat array package. But I think re-doing the formatting to allow another column is probably less stressful than trying to create some comprehensive array thingy.

Although, if I had to do this without adjusting the formatting, does anyone know how to create formula that wouldn't require adding another column?

Thanks again,
-T.Z.