Saturday, May 28, 2011

Merge two CSV files to a single file Excel worksheet based on a common/unique key

If you have two CSV files (any delimited files) that have a common field, sometimes we need to merge the data into a single worksheet.  Intelligently use VLOOKUP function as explained here to accomplish this task.

http://www.howtogeek.com/howto/13780/using-vlookup-in-excel/

No comments:

Post a Comment