Tech & Development Prompts Describe what you need your spreadsheet to do — get the exact formula, why it works, and what breaks it. Paste this prompt into Claude, ChatGPT, or any AI chat, describe what you want your data to do in plain English, and get back the exact, ready-to-paste formula for your version of Excel or Google Sheets — plus a plain-English breakdown of how it works and the specific ways that formula type tends to fail. This isn't a "here's a VLOOKUP, good luck" answer. It flags version compatibility between 365 dynamic arrays, legacy CSE array formulas, and Google Sheets syntax, hands you a backup formula approach with honest trade-offs, and gives you a testing checklist before you trust the output on a live sheet. Works with Claude, ChatGPT, or any AI chat model. What you get One production-ready prompt (600+ words) The exact, ready-to-paste formula with every cell/range reference clearly marked A plain-English, step-by-step explanation of how the formula works Common pitfalls and errors flagged before they happen (#N/A, #REF!, #SPILL!) An alternative formula approach plus a live-sheet testing checklist Sub-types covered VLOOKUP & XLOOKUP INDEX/MATCH Dynamic Arrays Nested IF Logic Google Sheets Syntax Excel 365 & Legacy Financial Formulas ai-excel-formula-generator-prompt.txt · Works with Claude, ChatGPT & more · Instant use
