You're a procurement analyst tagging this quarter's purchase orders with each vendor's risk rating from the vendor master. Columns A–B contain 8 POs and their vendor IDs.
Your task:
- In column C (Risk Rating), return each vendor's risk rating using exact-match XLOOKUP (or VLOOKUP with the 4th argument set to FALSE).
Vendor master (build on the sheet or use inline arrays):
- V-103 → Low
- V-208 → Medium
- V-411 → Low
- V-565 → High
- V-789 → Medium
Graded cells: C2, C6, C8.
Open this problem on a desktop to attempt it.