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
|