In position!B4 and copy down and across, =INDEX(employee!$A$4:$A$7, MATCH(position!$A4, employee!B$4:B$7, 0))