Pull Sarah's salary band before the comp review
FP&A is finalising next year's compensation bands. Sarah's grade just changed to G4 and finance needs the matching base salary plugged into the comp model before the 4pm review.
Look up employee salary grade
Practice using VLOOKUP to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
You're an FP&A analyst reviewing compensation data. You have a salary grade table and need to find the base salary for grade level "G4".
Return the base salary that matches Sarah's grade. Fill the Salary cell in the Lookup mini-table on the right of the sheet.
VLOOKUP searches the first column of a table for a value, then returns a value from a column you specify to the right. It's the most common lookup pattern in Excel: 'find this ID, return the matching name'. The fourth argument controls the match type, and almost always wants to be FALSE for exact match.
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Try the formula first. Hints cost CP for a reason.