Thread
:
Replacing a number value with text from array
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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
Reply With Quote