Marta keeps the hire price list for a scaffolding firm in Katowice and needs a rate to appear beside a product code. Every tutorial she found used XLOOKUP. Her office runs Office 2019, so the cell answers #NAME?, and the hour she spent assuming she had mistyped it is the single most common hour lost in this topic.
The version she has does the job with two functions instead of one. =INDEX(prices, MATCH(A2, codes, 0)) takes the code in A2, finds which row of codes it sits in, and returns that row of prices. INDEX and MATCH work in every version anybody still runs, they have done for twenty years, and the zero at the end is the argument that says exact match rather than nearest, which is the one people leave out and then wonder why a code returns the price of a different item.
prices and codes are not cell ranges typed into the formula, they are names given to two columns once, on the Formulas tab. Name a range once and the formula stops breaking when a column moves, which is the difference between a sheet that survives a colleague inserting a column in March and one that quietly returns the wrong rate from then on. It is also why the formula above reads like a sentence rather than like coordinates, and a sheet somebody else can read is the whole of what makes a spreadsheet a shared tool rather than a private one.
The same idea carries the other function worth knowing here. =SUMIFS(hours, person, A2, month, B2) adds up the hours column for every row where person matches A2 and month matches B2, and between it and the lookup above sits most of what an office spreadsheet is ever asked to do.
The two ideas that survive an upgrade
Word has one and it is the same shape. A heading that is bold 16 point is not a heading, it is body text in bold, and Word cannot tell the difference between it and a sentence somebody emphasised. Apply Heading 1 and Heading 2 instead and three things happen at once that no amount of manual formatting produces: the contents page builds itself and updates, the navigation pane becomes a working table of contents, and changing the look of every heading in a 60 page document is one edit rather than 60. The reason documents stop staying formatted is almost always that the structure was drawn by eye.
PowerPoint's version is the slide master. Change the font in the slide master, not on the slides, and the deck stays consistent when somebody adds a slide next month by copying an old one. Doing it slide by slide works and it holds until the first person who was not in the room touches it, which is the point at which every hour spent on it is spent again.
Neither of those is a feature. Both are the same idea appearing three times: put the definition in one place and point at it, rather than repeating the result everywhere. That idea is why this topic is worth reading in order once, even though nobody ever does.
The stall is learning where the button is
Here is where people stop, and it is invisible because it looks exactly like competence. The click path gets memorised: this menu, that tab, the third icon. It works, it is fast, and it is worth nothing the moment the build changes, the ribbon is rearranged, or the file is opened in the browser version. Ten years of that produces somebody who is quick in one program on one machine and helpless beside it, and who reasonably concludes that the software keeps being changed to annoy them.
The check is whether an answer transfers. Ask what a thing is called rather than where it is: a named range, a style, a master, a rule. A person who knows the name can find it in a version they have never opened, in a menu that has moved, and in Google Sheets, which uses the same words for the same ideas. A person who knows the coordinates has to be retaught every time, and the retraining is what makes this topic feel endless.
The lookup
Two ways to put a price beside a code
No ticks on this one, because which column is correct is decided by the machine you are sitting at rather than by the merits.
The last row is the one that is the same on both sides, and it is there because it is the row people expect to differ. The naming is what protects the formula, not the choice of function.
What to open in 2026
Excel is the one to know, in whichever build is in front of you, and it replaced the printed manual that could assume one version existed. The useful and underused fact is that Excel for the web is free with a Microsoft account and carries the current function set, which means somebody stuck on a 2019 desktop can open the same file in a browser and use the newer function there. That is often a faster route than arguing for a licence.
Google Sheets is free with an account and it replaced emailing a workbook round and merging the replies by hand, which is still how a surprising number of offices work. It matters here for a second reason: it has the current function set for everybody, regardless of what is installed, so a version problem can be stepped around rather than solved. The cost is real and worth saying, which is that heavy conditional formatting and very large sheets are still slower there than on a desktop Excel.
LibreOffice Calc is free, opens and writes xlsx, and it replaced buying a suite in order to read a file somebody sent you. The honest limit is compatibility at the edges: the formulas above work, and a workbook full of macros, pivot charts and conditional formatting will not come across cleanly. It is the right answer for reading and for ordinary work, and the wrong one for a file that has to go back to somebody running Excel.
Six clusters, entered one question at a time
The most used analysis tool in the world carries nine pages of its own and is where most people arrive, usually with a formula that will not do what a tutorial said it would. Documents that stay formatted is one idea long, and it is the idea above. Slides, whatever your opinion of them is the master, the placeholder, and the small number of things that make a deck editable by somebody else.
The application most of the day is spent in is the one people never think to learn, on the grounds that email is not a skill, and it is where rules and search operators buy back the most time per hour invested of anything on this page. Working in the same document at the same time is the one that changed most since 2020 and the one where habits from the emailed-attachment era do the most damage. The rest of the suite you will meet is exactly what it says and is best read the week somebody sends you a file from one of them.
This topic is the room rather than the subject. What is being done in the room belongs elsewhere: a sheet holding a chain of dependent tasks is delivering something by a date, with other people, a document written to be acted on is being understood, in every form the job takes, and the hours the inbox takes are counted in getting your own work done, reliably. All six sit under running work, getting paid, and the software it happens in.
Marta will hit the next one this week, and it is not a software problem: the sheet is right and nobody trusts it. Her rate lookup now works and returns a number three people still check by hand against a printed list, because the printed list is what they have always checked against and nobody has ever shown them why the sheet is more reliable than the paper. That is not a software problem and there is no page for it under this topic.