I just got sent a spreadsheet, obviously written by someone who doesn't actually use it, with countless vlookups against huge, whole column arrays!
I've shortened all those ranges down and converted to index/match which has obviously helped massively.
Im thinking to change to...