Match the Target — Department-of-Record Codes

You're an HR analyst reconciling internal department names against the system-of-record's "Department-of-Record" codes. Columns A–B contain 8 employees with their internal department names. Column E (Target Code) shows the expected DoR code per employee — that's the column the corporate report needs to match.

You don't have the internal-name → DoR-code mapping documented anywhere. You need to derive the mapping from the target column itself, build a small lookup table on the sheet, then use VLOOKUP (or XLOOKUP) to produce a parallel "Your Code" column at column D that exactly matches column E for every row.

Your task:

1. Read column E to infer the mapping.
2. Build the lookup table somewhere on the sheet (e.g., G2:H6).
3. Write a formula in column D that uses the lookup to produce values matching column E.

The grader checks column D against the spec — column E is your visual sanity-check.

Graded cells: D3, D6, D9.