Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Format Number to Text | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |