Replacing a number value with text from array

[JB1981]

I need to be able to replace customer ID numbers with the customer name
on a massive scale. Is there any way i can say "13562 = Costco" for
about 3000 different IDs. I have the master list of ids to names, but
how would i go about doing a mass replace like this?

Cant do a sort and cut/paste because some entries have the same
customer id number.

IE.

13562
13562
14200
15873
15873
15873

Thanks!
JB

 

[Ardus Petus]

Say your master list (ID - Name) is in F1:G999
and the list of IDs is in A1:A100

In B1, enter:
=VLOOKUP(A1,F1:G999,2,0)
and drag down the formula

HTH

 

[Guest]

Hi, try to use vlookup to put on the colum B for example the names, copy and
past special values to column A.(assuming that the codes "13562" are on the
column A)

regards from Brazil
Marcelo

"JB1981" escreveu:

 

[JB1981]

Great! got the look up to work, but when i copy the formula down it
changes all of the cell values

=VLOOKUP(A3, C222,2,0)
=VLOOKUP(A4, C323,2,0)
=VLOOKUP(A5, C424,2,0)

need it to just change the A column, and keep the C222,2,0 the same.
Any ideas?

Thanks!

 

[Ardus Petus]

=VLOOKUP(A2,c$2$22,2,0)

HTH

 

[JB1981]

You Da' Ma