Faster way to do this!

[jrramz22]

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 way to put in those names instead of doing it manually.

[#2]

Can you post a sample workbook please?

[#3]

@Jan Karel Pieterse 

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. 

[#4]

 

@jrramz22 

[#5]

Hi @jrramz22 

Something like this?

[#6]

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 

[#7]

Have a look at the vlookup function.

[#8]

You would need 25 names in this instance.

[#9]

@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.

[#10]

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. . @Jan Karel Pieterse 

[#11]

@jrramz22 I'm sorry, but I have no idea what it is you are trying to achieve with this list.

[#12]

May be you can try find and replace@jrramz22 

[#13]

That is Okay! I am sorry, I've probably been explain it harder that it really is. 

On the attachment I sent, this is what it should looks like when I am working on it. What I am trying to do is to put the names that belong to that 3 letter code (Column A), but find the easiest possible way to do that instead of doing it all manually. I have a list so I know where the names belong to in that 3 letter code.

If you are still confused that is okay, thanks! @Jan Karel Pieterse 

[#14]

you can also use flash fill

[#15]

I tried that, but when it auto fills it does it incorrectly. @Saty_Rana 

[#16]

i did it...i think

[#17]

This is just a small example... when I do it when i am in the middle of finishing it use auto fill and when i look its mostly all incorrect... Ill give it a try and see what happens with this small example.@Saty_Rana 

[#18]

move the data from row D to row F, Now use formula =VLOOKUP(B2,E$2:F$55,2,FALSE) in A2, Drag it till last cell, it would fill al the cells@jrramz22 

[#19]

Huh... when I type in the formula I got an error...@Saty_Rana 

[#20]

see my sheet, tell if you exactly wanted same or something else????
you need to move data from row D to row F