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