Re: multiple criteria match showing mixed results
Thanks Dave, for trying. The data changed because I can't use real names, etc from my company online and I am at a different computer than previous posts so I had to create new examples. In my first post I was trying to show you where the data needed to end up - on mailing labels. I shouldn't have it confused the issue, I only need to get Excel to format it for use in a mail merge with Word and then I can get the mailing labels from there. Pivot Tables would be great if I was just collecting info, but I can't see how it could work for printing over a thousand labels at one time - in your example I could see the data I needed, but it only displayed one at a time and only showed one seat.
Thanks again for trying. If I figure this out..and I have to lol...I will post an example.