Many thanks Pecoflyer.

I doubt if I would have been able to figure this out. I was working with Index and Match and going nowhere quickly.

In my actual spreadsheet, I do have the names in the first column, and I wish I had placed that portion in my test sheet as I can now see why it would have been easier to pull the data.

Thank you for all your help.

David