I am trying to use the functions above as opposed to Vlookup to place the new salaries for the staff from sheet 2 to sheet 1.
The new salaries are in Sheet 2 and are sorted by Staff ID.
I want these salaries to reflect in Sheet 1 but located in Column J thereby replacing the old salary figures there.
I have tried this with my actual data set and have got error messages ranging from #Ref to N/A.
I have tried to make sure I have the same data in both sheets as i discovered that if there is a name on one sheet that is not on the other it throws off the formula.
Also i thought that with this function, i did not have to worry about sorting my data but that appears not to be the case.
Here is the formula I used for my actual data set
INDEX(Sheet1!$E$2:$E$245,MATCH(Sheet1!A51,'3WORKINPROGRESS'!$D$2:$D$245,0))
Sheet1E2:E245 is where the new salary values are
Sheet1 Column A is where the Staff ID is (both are on the same sheet)
D2:D245 is where the staff ID with the old salaries are located (different sheet to the above)
I am sorry this is long, but i hope someone can understand what i am saying and use the sample sheets attached to lay out the correct structure and show me where I am going wrong.
