I have 2 sheets in 1 excel file 500 rows need to make it so that if
Sheet1:ColB is the same as Sheet2:Colb then the Notes in
Columc:Sheet2 are displayed in sheet1ColumC

note that in most cases the infomation in Colb wont be in the same
order etc. and also a few records missing if this is the case i would
like it to be blank.

Cheers