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
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
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
    (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 

Resources