Credit Prospect File to Append.xlsxKey-Credit Codes wCredit Limits 2013-01-14.xls

I need to take the attached credit prospect file attached and by using the attached look up table, I need to append the file using the different critera defined within the look up table.
I hope you all can help, I have been strugling with this for days.