Search: "INDEX MATCH"

#excel #index match #formula

excel Advanced

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#coding #sql #performance

coding Advanced

SQL Query Optimizer With EXPLAIN Plan Walk-Through

I have a slow SQL query against [DB ENGINE — Postgres / MySQL / SQL Server]. The...

#design #color #accessibility

design Intermediate

Audit a Color Palette for Accessibility and Brand Coherence

Audit my color palette. Check: WCAG contrast for text on each background pair, c...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

productivity intermediate

Team Task Delegation Framework

Help me create a delegation framework for assigning tasks to my team of [team si...

#productivity #delegation #team-management

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#SEO blog post #long-form content #content marketing

writing intermediate

Long-Form SEO Blog Post: 2000+ Word Structure and Outline Guide

Help me create a comprehensive, SEO-optimized blog post on the topic: "[your top...

#coding #database #migration

coding Intermediate

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

#expense report #auto-categorization #budget tracking

Expense Report Template with Auto-Categorization

Create a comprehensive Excel expense report template with these features: 1. In...

#sql migration prompt #rollback safe deployment #database schema change

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#hr #compensation #salary-bands

hr advanced

Compensation Benchmarking and Salary Bands

Help me design a compensation benchmarking framework and salary band structure f...

#TypeScript #utility functions #JavaScript

coding intermediate

JavaScript TypeScript Generic Utility Functions Library

Create a TypeScript utility functions library with these categories: 1) Array ut...

#newsletter #email #writing

writing intermediate

Newsletter Issue Writing Template for Niche Audience

Write a weekly newsletter issue for [newsletter name and niche]. Structure: 1) P...

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#marketing #paid search #ppc

marketing Advanced

Paid Search Campaign Brief with Negative Keyword Strategy

Act as a paid search strategist. Build a campaign brief for [BUSINESS] launching...

#hr #offer-letter #equity

hr Advanced

Write an Offer Letter for a Senior Engineer Including Equity Vesting Terms

Draft a professional offer letter for a Senior Software Engineer in the US (Cali...

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

coding Intermediate

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration