Forum Discussion

jrramz22's avatar
jrramz22
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...
Charting
excel
Excel for web
Formulas and Functions
JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 18, 2019

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

jrramz22's avatar
jrramz22
Copper Contributor
Dec 18, 2019

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! JKPieterse 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    (y) greetings
  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

    Thank you so much for you help! Ill look more into vlookup!Saty_Rana 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    he is really amazing person...regards
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Dec 18, 2019
    No, Sergei is a real person, we've met some years ago. 🙂
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    its a compliment, coz you know links to everything....
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    are you a bot???
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    cheears!!!!!!!!!!
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    =VLOOKUP(B2,E$2:F$55,2,FALSE)

    here dollar signs are placeed so that cell id dont change i.e. E2:F55 to B3:F56 when you drag it down and so on, like flashfill

    2 here is the row number from where to pick up data

    false here means exact match



    see tutorial on vlookup for more info
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    Indian Jugaad.... am really happy it worked 🙂
  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

    Oh my gosh it worked!! lol So this is just a small example of what I really do but i will apply it to my actual sheet. Anyway you can tell me what everything in that formula means? Such as  the $, the 2, and the FALSE.

     

    Thank you! Saty_Rana 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    you need to clear your concept a little on vlookup, try watching a tutorial on youtube. its an easy topic and would help you alot
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    the data you have placed is wrong. you need to interchange data in row E and F
  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    have you placed $ sign correctly??
  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

    This is exactly what I am looking for! but I still seem to get an error when i moved row D to Row F and when I made move it to look exactly like yours. Saty_Rana 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    see my sheet, tell if you exactly wanted same or something else????
    you need to move data from row D to row F
  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

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

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019

    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 cellsjrramz22 

  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

    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 

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    i did it...i think
  • jrramz22's avatar
    jrramz22
    Copper Contributor
    Dec 18, 2019

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

  • Saty_Rana's avatar
    Saty_Rana
    Brass Contributor
    Dec 18, 2019
    you can also use flash fill

Resources