FORMULA OR VBA Code for my attached work

i have an EXCEL Work book contains with two sheet. in sheet1 there are three columns named with Column A - Chasis Number , Column B - License ID,and Column C - Chasis Number.all columns are filled wi...