Report returns numbers that represent names - I want the names!

I download a report that gives me numbers that represent customer names, like this:

1= Customer1
2= Customer 2
3= Customer 3
...
30= Customer 30

so my report in column A is randomized and extends hundreds of rows.

1
11
2
23
15
2
3
30
12

Each Customer has it's own group of accounts:

Customer 1 = 1, 2, 3
in which 1 = CA, 2 = FL, 3 = MN
Customer 2 = 1, 2
in which 1 = OR, 2 = ND
...
Customer 30 = 1, 2
in which 1 = MA, 2 = GA

So Column B looks like this

1
2
3
1
2
3
3
2
3
2
1

I want to create two columns, C & D that return the Customer Name and the customer Account.

Column C (Dependent on Column A - CustomerNo)
Customer 1
Customer 11
Customer 2
...

Column D (Dependent on Column A & Column B - CustomerNo > AccountNo)
GA
MN
CA

Do I need VBA? I just got a book for it but I'm only on chapter 6 so I haven't discovered the answer yet. Is it possible to do this with just a formula alone?

I appreciate the time, thanks for reading.

If you've got tables of values set up within the workbook to look up the customer names and the accounts then you can use some look up formulas...

If you can attach a workbook with some sample (non-confidential) data, we may be able to help.

In D2:

Please Login or Register  to view this content.

in E2:

Please Login or Register  to view this content.

in F2:

Please Login or Register  to view this content.

adjust ranges in each to suit your real data and copy them down the table.

You are welcome,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save