using vlookup

Using VLookup like Batch script to compare two excel / csv

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 you want to put compared value: B2 Click on fx button and select VLOOKUP function. Under lookup_value, click first search field: A2. Click back in Table_array text field, and click on button to select range. Select two column for comparison starting from second row, i.e....