Felix & Ken,
Thank you both for the quick response!

I went with felix's solution and the index function worked perfectly.

Ken, I'm sure yours would have worked equally well but my pointy little
head seems to grasp functions better than VBA . Still thanks for your
reply.