I need a help guys.I have one excel sheet where id,Name and salary column is made in which there is some data available in each column except salary column which is to be blank for the time being.
I have another excel sheet where In column Id the same data as in Data 1 is available but in random order and in salary column there are some values for each id.
what i need to do is to retrieve the salary credentials from Data 2 and put it into the Data 1 and the amount should be same for the id given in Data 2 sheet.
I am attaching the sheet
Data1.xlsx (7.9 KB)
Data2.xlsx (7.9 KB)