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.
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