1 article

Office & productivity articles

Getting more from the tools every office runs on: Excel, documents, presentations and tidy workflows.

Hands on a laptop keyboard, the screen showing a gallery of chart types, with a green highlighter and a potted plant on the desk.

XLOOKUP vs VLOOKUP: which should you use in Excel?

Use XLOOKUP if everyone who opens the file has a recent version of Excel. Here's how both functions work, the four traps VLOOKUP sets, and when the old one still earns its place.

2 October 2026 · 8 min read

Learn it properly

Ready to go beyond the blog?

Our office & productivity courses turn these articles into skills, with interactive lessons, real projects and a certificate employers can verify.

See the courses Get the free info pack

Free info pack

Reading up before you choose? Take the info pack.

Every course in the school with its price, how they fit together and where to start. Yours free, and it opens straight away.

Every course in the school, with prices
Where to start, whatever your experience
The OBA Tutor and Career Centre, explained

Takes 30 seconds

Send me the info pack

First name

Last name

Email address

Phone number

Don't send me marketing emails

By sending this you agree to marketing emails from OBA. Unsubscribe any time.