Salary Lookup by Department

You're an HR analyst preparing a compensation review. The spreadsheet contains employee records in columns A–E.

Your task:

1. In column F (Target Salary), use VLOOKUP or XLOOKUP to look up the target salary for each employee based on their Department (column C).

Use this reference table (you'll need to build it somewhere on the sheet): Engineering → 90000 Marketing → 65000 Sales → 55000

Graded cells: F2, F5, F6