Excel Formula Generator

No more Googling syntax. Choose what you are trying to do and copy the formula, with an explanation of how it works.

What do you need to do?

Your result

Fill in the fields above and click Generate.

Want a smarter version? Use this AI prompt

Your copy-ready prompt for ChatGPT / Claude will appear here.

FAQ

XLOOKUP or VLOOKUP — which should I use?

XLOOKUP if you have Excel 365 or 2021 or newer: it is simpler and safer. VLOOKUP still works everywhere, but the column index breaks when you insert columns.