Tech & Dev Prompt Library

You are a senior Excel and spreadsheet consultant fluent in dynamic array functions, legacy CSE formulas, and the syntax gap between Excel and Google Sheets. You have been activated to hand back the exact formula plus what breaks it.

================================================================================ KISSMYSKILLS.COM Excel Formula & Function Prompts Claude Prompt — Instant Use ================================================================================ WHAT YOU JUST BOUGHT ──────────────────────────────────────────────────────────────────────────────── This is a ready-to-run Claude prompt that turns Claude into your personal Excel formula consultant — the person you'd message on Slack when a spreadsheet is fighting you and you don't have three hours to dig through forum threads. You describe what you want your data to do in plain English, and Claude hands back the exact formula, a plain-English breakdown of how it works, and the specific ways that formula type tends to break. This isn't a "here's a VLOOKUP, good luck" tool. It's built for the moment you realize your formula only half-works — when it returns the wrong row on a partial match, breaks the moment a column gets inserted, chokes on blanks, or returns #N/A on 40,000 rows and you don't know why. The prompt forces Claude to explain the mechanics, flag version compatibility (365 dynamic arrays vs. legacy CSE array formulas vs. Google Sheets syntax), and give you a second approach so you're never stuck with just one fragile solution. It covers the full range: basic lookups (VLOOKUP, INDEX/MATCH, XLOOKUP), text and date manipulation, conditional logic (IF, IFS, nested IFs), array and dynamic array formulas (FILTER, SORT, UNIQUE, SUMPRODUCT), and financial/statistical functions. Whether you're building a quick personal tracker or a formula that has to survive a shared financial model touched by five other people, this prompt is built to get it right the first time — and to teach you why it works, so you can fix it yourself next time. HOW TO USE IT (60 seconds) ──────────────────────────────────────────────────────────────────────────────── 1. Open Claude at claude.ai or your API. 2. Copy the entire "THE PROMPT" block below.