Why also sorting by row? And why are vlookups the devil? my undergrad was finance, but I've self-learned a lot of CS.

It's possible to sort just a single column, leaving all the columns beside it in their original sort order. That's very bad if you want to keep your rows in one piece.