Replacing a number value with text from array

J

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
 
A

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
 
M

Marcelo

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:
 
J

JB1981

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

=VLOOKUP(A3, C2:D22,2,0)
=VLOOKUP(A4, C3:D23,2,0)
=VLOOKUP(A5, C4:D24,2,0)

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

Thanks!
 
Top