Replacing a list of codes with names
 

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?

Replacing a list of codes with names
 

In B1 of your List2 sheet:

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

and copy down.

Hope this helps.

Pete

On May 30, 11:39*am, Mortir wrote:
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?

Replacing a list of codes with names
 

On May 30, 12:45*pm, Pete_UK wrote:
In B1 of your List2 sheet:

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

and copy down.

Hope this helps.

Pete

On May 30, 11:39*am, Mortir wrote:



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?- Hide quoted text -

- Show quoted text -

great thnx a lot Pete!

Replacing a list of codes with names
 

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

Pete

On May 30, 12:00*pm, Mortir wrote:
On May 30, 12:45*pm, Pete_UK wrote:





In B1 of your List2 sheet:

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

and copy down.

Hope this helps.

Pete

On May 30, 11:39*am, Mortir wrote:

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?- Hide quoted text -

- Show quoted text -

great thnx a lot Pete!- Hide quoted text -

- Show quoted text -