Will the formula work in my version of Excel?

Choose Modern for dynamic arrays and XLOOKUP, or Excel 2019 compatible. The tool only uses functions that exist in the version you pick.

Can it use my actual columns?

Yes. Paste the header row plus a line or two of data and the formula references exactly those columns.

Excel Formula Generator

Type what you want in normal words and get a formula you can paste straight into Excel. Paste a couple of rows from your sheet and the column references match your real layout instead of guessing A, B and C.

Each answer explains how the formula works and offers alternatives: a modern version with XLOOKUP and a version that runs in Excel 2019 and older.

Describe what you need in plain words and get a working Excel formula, with column references matched to your own sheet.

Open the tool — this example is already filled in

Frequently asked questions

Will the formula work in my version of Excel?: Choose Modern for dynamic arrays and XLOOKUP, or Excel 2019 compatible. The tool only uses functions that exist in the version you pick.
Can it use my actual columns?: Yes. Paste the header row plus a line or two of data and the formula references exactly those columns.

Related tools

VLOOKUP Generator

Describe what to look up and get a working VLOOKUP, XLOOKUP or INDEX/MATCH formula with the ranges filled in.