For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=TOOLS.A1

Formula builder

Pick what you're trying to do, fill in your cells, and get the exact formula — updated live as you type.

Fields marked * are required.

Your formula
=XLOOKUP(D2, A:A, B:B, "Not found")

Tip: values in quotes are inserted as text — edit the formula directly if you need a number or cell reference instead.

Learn more: XLOOKUP(), VLOOKUP()

What it does

Choose the job you are trying to do — look a value up, sum with conditions, count matching rows, split text — then fill in which cells hold your data. The builder assembles the formula with the arguments in the right order and in the right places.

The problem it solves

Most Excel difficulty is not knowing that a function exists. It is remembering which argument comes first. A few of the ones that catch everybody:

Check these before you trust the output

A generated formula is a draft. Two things to verify every time:

Where to go deeper

Each function has a reference page with its full argument list, worked examples, and related functions —VLOOKUP,XLOOKUP,SUMIFS, andthe rest of the reference. For the lookup decision specifically,XLOOKUP vs INDEX/MATCHcovers which one suits your Excel version.

Privacy

Nothing leaves your browser. Cell references you type are not uploaded or stored anywhere.