Cell G10 will ALWAYS have a value under the following format:

XX-14-##, XXX-15-##, XXXX-14-##

Where the first letters (they will always be letters) BEFORE the hypen ("-"), represent a Contractor code

The 2 numbers between the hyphens represent the year (14 = 2014)

The LAST 2 numbers (the ones AFTER THE HYPHEN) represent the district.

Based on the value of G10, how can I have J5 give me the district (I have a separate tab that lists the districts: column D is district number, column E is District Name (what I want), column F is Region name)?

Based on G10, How can I have J6 give me the region?

Based on G10, How can I have J9 give me the contractor name(the separate tab that I have also lists the contractors: column A is the contractor code, column B is the Contractor name.)?
Note: the code SCE will NEVER APPEAR, but instead MW, ME, NC, DE, OR, RLN, RLS, SJC, SJOA.

If an upload is needed, let me know and I'll put it up.