Forum Discussion

Pamela Galpern's avatar
Pamela Galpern
Copper Contributor
Jul 28, 2017

Replace multiple items at once

I have a list of about 200 codes, each representing a different location. How can I fill in the proper location for each code based on one master list (e.g. 30-022 = 250 West 30 St, NY NY)? Thank you.

excel

2 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Jul 29, 2017

    Hello,

     

    if you have a master list of codes and locations, then you can use a lookup formula for this. If the code is the first column in the master list, then you can use Vlookup, for example like this

     

    =Vlookup(A1,MasterList,2,false)

     

    If the code is not the first column in the master list, then you can use a combination of Index/Match, like this, assuming the master list code is in column F and the master list location is in column E

     

    =index($E$1:$E$100,match(A1,$F$1:$F$100,0))

     

    If you find these formulas confusing and don't know how to apply them to your data, then that may give you a taste of the confusion we experience when faced with a question that does not show the data structure. So, if you need further help, please attach a sample file. 

     

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Iron Contributor
    Jul 29, 2017

    Hi Pamela Galpern,

     

    Your problem is not clear to me.

     

    So, Can you give some samples in 200 list and Master?

     

    Coz, then only i suggest VLOOKUP or REPLACE function which will solve.

Resources