Forum Discussion

Copper Contributor

Sep 13, 2019

Faster way to do this!

I have a set of reoccurring data that has the same letters through out the columns in different orders, and I need to insert names to those reoccurring sets of data. My question is, is there a faster...

Formulas and Functions

Copper Contributor

Dec 13, 2019

Sorry for the late reply about this. Those letters to the left (THO, SHH, etc) I have, but how do I add the ones to the right much easier(West, Loan, Super, etc)? Instead of having to manually add those in there one by one and dragging them down. I have over 1000 rows of this.

Copper Contributor

Dec 13, 2019

JKPieterse
Silver Contributor
Dec 16, 2019
jrramz22 Can you please upload a (sanitized) copy of your file with just the long list of codes and the list of 25 names and their codes? I'm sure this requires a simple VLOOKUP rather than the complicated 25-level nested IF formula.
- jrramz22
  Copper Contributor
  Dec 18, 2019
  This is just a shorten down example. I tried to look up videos on Vlookup but no luck. If you can show me how that is done that will be great.
  Let me know if you need more information. . JKPieterse
  ExcelForumHelp.xlsx11 KB
  - Saty_Rana
    Brass Contributor
    Dec 18, 2019
    May be you can try find and replacejrramz22
Fortijo
Copper Contributor
Dec 13, 2019
Hi jrramz22
Something like this?
- jrramz22
  Copper Contributor
  Dec 13, 2019
  Yes, exactly like that. BUT I have over 170 different names in that A Column, and over 1000 rows that need to be filled. That was a short example of what I am trying to do.
  
  I have about 25 Names and those names go to a specific 3 letter code (there are about 170 different 3 letter codes) , and I have about 1000 of those 3 letter codes those names belong to.
  
  Would I have to have a really long formula to execute this? Fortijo
  - Fortijo
    Copper Contributor
    Dec 13, 2019
    You would need 25 names in this instance.

Resources