The simple method
Create one VLOOKUP formula for each return column. One formula returns email, another returns department, another returns status. This is easy to understand but can become hard to maintain across large reports.
Using MATCH with VLOOKUP
When headers may move, MATCH can find the correct column number dynamically. This reduces the risk of returning the wrong column after someone inserts or reorders columns.
When XLOOKUP is cleaner
XLOOKUP can return from specific result ranges and may be easier to read than repeated VLOOKUP formulas. For modern Excel users, it is usually the cleaner option.
When a report is better
If you need multiple columns plus missing records, duplicates and conflicts, do not rely only on formulas. A reconciliation report gives a fuller picture and is easier to review with management.
ReconNimble method
ReconNimble outputs matched rows and action sheets with the relevant fields side by side, so you do not have to build multiple lookup formulas manually.