Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2 from File1. Solution: VLookup in excel Steps: Open both files in Excel & arrange it vertically (Window >> Arrange; for ease) Click on cell where […]

The post Using VLookup like Batch script to compare two excel / csv first appeared on ..::CHANGE is INEVITABLE::...