Challenge

Reports come out of one system with only names but need to be imported into another system using IDs.

Solution

Create a crosswalk spreadsheet to automatically match names to their correct ID number. Any Names that do not match are kicked out as an exception for manual review and addition to the crosswalk.

Results

Users are free to concentrate on other tasks, fewer errors, crosswalk automatically grows