Context
Cross-referencing SKUs against EU regulatory requirements by hand was slow and prone to transcription errors, especially for products distributed through the Cayman Islands where the applicable requirements weren't always fully met.
Automation • Career Development
SKU List Automation (VLOOKUP)
Duration: 6 months • Role: Process Improvement Lead
A manual review flagged SKUs sold in the Cayman Islands that weren't completely following EU regulations. A manual SKU comparison doesn't scale, so building the VLOOKUP once turned a repeatable, error-prone manual task into a self-checking one.
Primary Risks Identified
- A silent mismatch (e.g. an unflagged non-compliant SKU or region) if the lookup isn't validated against a known-correct sample first
Testing Approach
Built and tested VLOOKUP formulas against the SKU/regulatory reference lists, validating a sample of matches by hand before rolling the formula out across the full list.
Excel
VLOOKUP
Manual Sample Validation
Outcome
Built a VLOOKUP-based SKU list comparison tool, cutting the manual cross-referencing time and reducing transcription errors.
Key Lessons
A manual SKU comparison doesn't scale - building the VLOOKUP once turned a repeatable, error-prone manual task into a self-checking one.
Have a system like this?
If you have no idea of testing your current system, let's talk through what's actually going on.
Contact me