Episode 1: XLOOKUP – Why VLOOKUP is officially retired

Modern Excel for Professional Services: 5 Functions Changing How We Work

Excel underpins daily operations in legal firms.

It supports billing analysis, WIP reviews, forecasting and partner reporting. Yet many teams still rely on legacy formulas and manual fixes that introduce risk.

Excel has moved on. Modern functions deliver stronger accuracy, clearer structure and better auditability. When used well, they improve control and confidence.

This series explores five functions that are reshaping how legal teams manage data. Each episode explains what the function does, why it matters and how it applies in practice.

We begin with XLOOKUP — and why VLOOKUP no longer meets the demands of modern legal reporting.

Excel remains a core tool across the legal sector – from finance teams and practice managers to partners reviewing performance data.
Matter lists. Billing exports. WIP schedules. Time recording reports.
And for years, one function has been the default for searching and matching data:
VLOOKUP
But today, VLOOKUP is effectively retired.

Not because it no longer works – but because modern legal reporting requires greater accuracy, flexibility, and auditability.

The problem with VLOOKUP:

• It only searches left to right
• It breaks when columns are inserted or moved
• It relies on column index numbers (difficult to review)
• It can return incorrect results if exact match settings are missed

In a law firm environment, even small spreadsheet errors can create unnecessary risk – particularly in billing, matter management, or partner reporting.