Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.

Almost everyone who uses Excel has that one function they’ve been relying on since college because it works well enough that they can avoid learning something new. That’s why you’ll still find VLOOKUP ...