Cell references

[Klartigue]

I have attached the spreadsheet i am working with. In column e, as you can see there is a list of broker codes. I would like to insert a column between E and F that contains the entire broker name. For example, in cell E2, AOCP exists. In a new column, i would like to display Angel Oak Capital Partners. So is there a macro that basically says when AOCP exists, write Angel Oak Capital Partners in the next cell?

Thanks,
Katherine

[Paul_Hossler]

If it does not need to be a macro, a simple 'decode' table and VLookup() would work

Paul