👋 Hey there, I am Waylon Walker
I am a Husband, Father of two beautiful children, Senior Python Developer currently working in the Data Engineering platform space. I am a continuous learner, and sha
For some reason I learned index and match first and vlookup never made sense to me. I always ended up in a case where I wanted something from the right, and the syntax didn't jive with me. vlookup is definitely more of a standard that you need to understand to work with any other Excel users.
I learned VLOOKUP first so that's my 'go to'. I find when trying to use INDEX - MATCH that I quickly end up with the spinning wheel of doom as Excel crunches through the function.
In most cases I just end up moving my columns around, and if it's too big for that it's time for a different tool.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
For some reason I learned
indexandmatchfirst and vlookup never made sense to me. I always ended up in a case where I wanted something from the right, and the syntax didn't jive with me.vlookupis definitely more of a standard that you need to understand to work with any other Excel users.I learned VLOOKUP first so that's my 'go to'. I find when trying to use INDEX - MATCH that I quickly end up with the spinning wheel of doom as Excel crunches through the function.
In most cases I just end up moving my columns around, and if it's too big for that it's time for a different tool.