Replacing a list of codes with names

[Mortir]

I have the following case:

a list of codes with names - LIST1

A B
1 X5A Jack Black
2 C7B John Doe
3 F5P George Bush

Now I have another list - LIST 2

A
1 Customer X5A
2 Customer F5P
3 Customer F5P
4 Customer C7B
.....

Now id like to change all the codes in LIST 2 with the names from
LIST 1

how can i do this?

 

[Pete_UK]

In B1 of your List2 sheet:

=VLOOKUP(RIGHT(A1,3),List1!A:B,2,0)

and copy down.

Hope this helps.

Pete

 

[Mortir]

In B1 of your List2 sheet:

=VLOOKUP(RIGHT(A1,3),List1!A:B,2,0)

and copy down.

Hope this helps.

Pete









- Show quoted text -

great thnx a lot Pete!

 

[Pete_UK]

You're welcome - thanks for taking the trouble to feed back.

Pete