What I need to do. I download a list of 'special' subscribers. I need to write a formula that will transfer these subscribers to a sheet for each group. A subscriber can have one product or multiple products. A group may have zero, one or multiple 'special' subs. I have to write a formula and I can not copy and paste even though that might be easier... lol. There is a one to one association of subno, groupno and name. A sub can not be in multiple groups. Each group has only one name. I am using the Index Match function, but it is not working right when I have multiple members with more than one product. Hopefully the link to my spreadsheet works