find mismatch in 2 columns

dear friends,
in the attached xls, col 1 and 2 are the master code and description respectively. in cols 3 & 4, i have my list of codes and description. however, i think that in col 3 and 4, some of the codes do not match the description (as compared to the master). i would like a solution that identifies the rows where the code and description in col 3 and col 4 do not match the master. thanks for your help.

yours sincerely

this can be achieved using a regular formula, no VBA required.

you can use the VLOOKUP function to search col A for a match with the col C value and return the respective value from col B, this can then be tested against the value in col D for equality

if you put the below formula in E2 and then fill down it will display either "True" or "False" for each respective row

=IF(D2=VLOOKUP(C2,A:B,2,FALSE),TRUE,FALSE)

you could also adapt this to work with conditional formatting e.g. highlight in red any values that don't match

put the below formula as the formatting rule for cell D1 and then apply the conditional formatting to the entire column

=VLOOKUP(C1,A:B,2,FALSE)<>D1

thanks
yours