How to format cell values based on codes for other values?

Preemptive apology for bumbling through this question.  I have a master table with two columns containing (A) codes and then (B) street names that match each code, i.e. | 275197_5 | MAIN ST |.  I hav...