Comparing Two Lists of Data

[capecodder]

So I have two lists of data that I need to compare. How would I go about comparing these two lists for matches and unique values? Should I use a Vlookup or Index match match? or is conditional formatting the best way to accomplish this task?

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
You could Use CF > New Rule> Use a formula > select Format
Use this formula =ISNA(MATCH(A2,$E$2:$E$20,0)) for finding unique values
Change ranges to suit.