vlookup

Hi all,
I am using vlookup to turn an imported 4 letter / digit code into detail.

I am hoping someone can help me shorten the process.

The data comes in as say

----col A
----AA21
----BB22
----AA22

The first 2 letters signify one detail and the second two signify another

Elsewhere I have a data sheet that gives me detail
i.e
---col L-----col M----col N----col O
----AA-------car-------21-----small
----BB------truck-----22------large

At present I text to columns splitting the AA21 into to extra columns giving me
---col B-----col C
----AA--------21

I then insert another column after column B.
In this column I then vlookup in col L & M the value in col B(AA) to return car.

I then insert another column after column D.
In this column I then vlookup in col N & O the value in col C (21) to return car.

Then I insert another column and join them together using =*&* to give me what I am looking for

car small
truck large
car large

The data that is imported has many different combinations.

This process works fine but I realise this is probably a long winded way of doing it which is why I am looking for a quicker way.

Apologies if the description is confusing.

Thank you in advance,

Greg.

Perfect Bruce,

thanks,

Greg.