Thanks Brian-really appreciate all your help and both formulas do the trick-thanks NBVC.

I am going through it to understand what you are doing.

I have also just started using index match instead of vlookups and it seems a lot more versatile.

Thanks again all-much appreciated