vba Match Two Sets of Data

hi, timbo1957, one of the options to obtain the result you need, run code "test". Please note, sheet names are hard-coded. if you change them the code will need changes as well.

Many thanks watersev works brilliantly.