Practice / Lookups

Difficulty 3 of 5 · about 4 min

Return a salary from a column left of the employee code

An HR export has the monthly salary (INR) in A2:A7, the employee name in column B, and the employee code in C2:C7. The code to look up is typed in E2. In F2, write a formula that returns that employee's salary. The salary column sits to the LEFT of the code column, so use INDEX and MATCH together, with an exact match.

Loading grid…