Replacing a number value with text from array
 

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


--
JB1981
------------------------------------------------------------------------
JB1981's Profile: http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586

Replacing a number value with text from array
 

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
--
AP


"JB1981" a écrit dans
le message de news: ...

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


--
JB1981
------------------------------------------------------------------------
JB1981's Profile:
http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586

Replacing a number value with text from array
 

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:


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


--
JB1981
------------------------------------------------------------------------
JB1981's Profile: http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586

Replacing a number value with text from array
 

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!


--
JB1981
------------------------------------------------------------------------
JB1981's Profile: http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586

Replacing a number value with text from array
 

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

HTH
--
AP

"JB1981" a écrit dans
le message de news: ...

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!


--
JB1981
------------------------------------------------------------------------
JB1981's Profile:
http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586

Replacing a number value with text from array
 

You Da' Man


--
JB1981
------------------------------------------------------------------------
JB1981's Profile: http://www.excelforum.com/member.php...o&userid=34807
View this thread: http://www.excelforum.com/showthread...hreadid=549586