[boppo1]

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

[orand]

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.

[boppo1]

Oh, duh yeah. That's such a natural thing to avoid I hadn't considered it