Forum Discussion
INDEX and MATCH Function help
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 thes...
Hi Joy,
I've updated the workbook you attached with the solution.
You can use either VLOOKUP or INDEX & MATCH as follows:
=VLOOKUP(D2,'Sheet 2'!$A$2:$D$7,4,0)
=INDEX('Sheet 2'!$D$2:$D$7,MATCH(D2,'Sheet 2'!$A$2:$A$7,0))
Hope that helps
Thanks a lot Haytham. It worked.
