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