Re: 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" <JB1981.291k9z_1149699607.201@xxxxxxxxxxxxxxxxxxxxx> a écrit dans
le message de news: JB1981.291k9z_1149699607.201@xxxxxxxxxxxxxxxxxxxxxxxx

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?action=getinfo&userid=34807
View this thread: http://www.excelforum.com/showthread.php?threadid=549586



.

Relevant Pages

  • RE: Just a little tease on how to place proper product spin.
    ... IDS may be ... horrendous of product positioning.> ... Product overlap also gives a customer choice. ... on with IBM. ...
    (comp.databases.informix)
  • Re: IDS 10 quality: Re: ODBC and F*&king IBM :-)
    ... I think Neil Truby first made note of assertions on ... IDS 10 here on CDI way back. ... and the customer is moving to that at the end of the World Cup ... the very biggest IBM customers do not necessarily have a field-based IBM ...
    (comp.databases.informix)
  • Re: IDS 11 - Press Releases
    ... again, right in step with taking what little sunshine Informix will get, ... "Will IDS ever outshine DB2? ... Cheetah is loaded with features that really make a difference... ... Support is really working to improve customer experience. ...
    (comp.databases.informix)
  • Re: Syntax to add records if primary key = list
    ... >>From a list of IDs that are the primary key in one table (i.e. Customer ... > Thanks for help with this low-level view of SQL programming. ... When you want to update ord_freight for known customer ids you can execute: ...
    (comp.databases.ms-sqlserver)
  • Re: Possible VB code to lookup and remove unwanted data
    ... Assume the unique customer IDs are in a sheet: ... In sheet: Data, assume the cust IDs are running in A2 down ...
    (microsoft.public.excel.misc)