Work · Spreadsheets
Generate a VLOOKUP formula in plain English
VLOOKUP is the formula everyone re-Googles. Describe your sheet in one sentence — what column has the key, what column has the answer — and the tool writes the correct VLOOKUP (or XLOOKUP) formula with a short explanation of how it works.
Try it now
Prefilled with an example. Edit the fields and run.
Example
Input
target: excel goal: Find the price for a product name in cell A2 by looking it up in the table Products!A:C where column C has the price layout:
Result
=VLOOKUP(A2, Products!A:C, 3, FALSE) How it works: looks up the value in A2 within the first column of Products!A:C and returns the value from column 3 (price). FALSE forces an exact match. Consider XLOOKUP if you use Excel 365: =XLOOKUP(A2, Products!A:A, Products!C:C).
Frequently asked questions
- Does it work with Google Sheets?
- Yes. Switch the target to Google Sheets and the formula uses Sheets syntax where it differs from Excel.
- Can it handle INDEX/MATCH or XLOOKUP too?
- Yes. Ask for either explicitly in the description and the generated formula will use it.
The tool behind this page
Excel FormulaPlain English to Excel / Google Sheets formula.Related use cases
- Extract action items from any textPaste an email thread, doc, or notes and pull out a clean checklist of tasks with owners and deadlines. Free AI action item extractor.
- Plan your day from a to-do listPaste your to-do list and get a realistic time-blocked day with breaks and buffer. Free AI daily planner, no sign-up.
- Brainstorm startup or product namesDescribe your product and get a varied list of startup, brand, or product name ideas — no duplicates or filler. Free AI brainstorm tool.