Try this...

In B2
=IFERROR(INDEX('Employee Salary History'!$B$2:$B$12,MATCH(C2,'Employee Salary History'!$C$2:$C$12)),"")
and copy down.

Is this what you are trying to achieve?