Good Afternoon Guys,
I'm doing a data migration and the HR department has provied with a matrix(basically a lookup table in excel format).
There are versions of courses in the source table that need to be converted into a course code or codes.
Example: Two Columns

I would like to setup a look table and or query so that I can convert these over automatically w/out doing it one by one.
Could someone point me in the right directions.

thanks,

Versions of Courses Course Code
MSLC: Zip Code Locator WBT Zip Code
MSLC: ZIP Code Locator - Web Link WBT Zip Code
UAD: ZIP Code Locator - Web Link_Deleted_03/09/2006-09:23:35 WBT Zip Code
MSLC: Visa Pre-Authorized Payment Cancellation Service WBT Visa
MSLC: UAD - Working with Sharechek Accounts WBT UAD SCA
MSLC: UAD Main Page II - Working With Sharechek Accounts WBT UAD SCA
MSLC: UAD Main Page II - Working With Sharechek Accounts ***This course is tempo WBT UAD SCA
MSLC: UAD Main Page II - Working With Savings Accounts ***THIS COURSE IS NO LONG WBT UAD SA
MSLC: UAD Main Page II - Working with Savings Accounts_Deleted_07/11/2005-08:31 WBT UAD SA
MSLC: UAD Functions - Ordering A New Card WBT UAD Order
MSLC: UAD - Navigating the Universal Agent Desktop WBT UAD Nav
MSLC: UAD - Navigating the Universal Agent Desktop Main Page WBT UAD Nav
MSLC: UAD - Navigating the Universal Agent Desktop Main Page***This course is te WBT UAD Nav
MSLC: UAD - Working with Mortgage Accounts WBT UAD MA