Macro to look at certain parts of a cell and compare?

Hi Everyone,

I'm not sure if a macro will help with this problem but I'll explain the situation and hopefully some one can help.

I have a list of Expense Codes in Column A. They look like this
0010-0020-8200-70.

Where
0010: Represents a Location
0020: Represnts the Business Type
8200-70: Represents Expense Type

I also have 3 tables on the spread sheet, which explains what these codes mean.

I need a macro that will look at the numbers in colum A and return the three types of expenses so they dont have to be looked up manually.

I hope this makes sense.
Can anybody help.

Thanks a bunch,
Nick