Lookup add-in for MS Excel

This add-in allows you to compare two Excel tables using one or several columns as the identifier, and copy specified columns values from the source workbook into target one.

Also you can highlight matched and not matched rows with different colours, and paste non-matching rows to the end of the target table.

Features
Video
Screenshots
Manuals

You can also do it using =VLOOKUP() formula, but

formulas may slow Excel down and inflate the file size
it needs too much time to enter formulas into a target file if you use new target table each day
for people who are not quite good in Excel it's easier to do it all clicking one button only