Forum Discussion

Max-NC's avatar
Max-NC
Copper Contributor
Dec 18, 2019

Matching Column C with D

I am trying to match Column C with D. Data in Column D is fixed. Data in Column C can be moved up or down, or deleted if no match is found in Column D. Matching values should end in the same row, ...
excel
Fortijo's avatar
Fortijo
Copper Contributor
Dec 18, 2019

Hi,Max-NC 

During my short time with the community I have learned to appreciate the amazing power of Vlookup.  Explaining it is harder than doing it - the formula is there - play around with it.  Curious if there is even a better way?  Thanks!

  • Max-NC's avatar
    Max-NC
    Copper Contributor
    Dec 18, 2019

    Fortijo 

     

    Can you please explain it step-by-step? That was like magic! Thanks