Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? It happens because QUERY doesn’t look impressive at first glance.

Spreadsheets are supposed to save time, but sometimes they just make things messier. I hated digging through endless menus until I found a handful of formulas that do the heavy lifting for me. VLOOKUP ...