Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "index match"

120 prompts matching "index match"

"index match" ✕ Clear all ✕
excel Intermediate

Excel XLOOKUP Formula Builder for Multi-Criteria Match

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

#xlookup #formulas #excel
👁 11 views
finance Intermediate

ChatGPT Prompt: Roth vs Traditional 401k Contribution Decision Framework

Help me decide between Roth and Traditional 401(k) contributions based on: - Cu...

#401k #roth ira #retirement planning
👁 11 views
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...

#excel #test-data #random
👁 11 views
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
👁 11 views
marketing intermediate

Google Ads Search Campaign Setup Optimization Complete Playbook

Build a comprehensive Google Ads search campaign from setup to optimization. Cov...

#marketing #google-ads #ppc
👁 10 views
coding Advanced

ChatGPT Prompt: REST API Endpoint Naming and Versioning Convention Reviewer

You are an API design reviewer. Audit my endpoint list for naming, REST semantic...

#coding #api #rest
👁 10 views
excel Intermediate

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#excel #dashboard #index-match
👁 10 views
excel Intermediate

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#excel #reconciliation #bank
👁 10 views
data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization
👁 9 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
finance Intermediate

Compare Two Job Offers Beyond Just the Salary

Help me compare two job offers honestly. Beyond base salary, include: equity (re...

#finance #career #job-offer
👁 9 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 9 views
design Intermediate

Heuristic Evaluation Using Nielsen's 10 Principles

Conduct a heuristic evaluation of [INTERFACE] using Nielsen's 10 usability heuri...

#heuristic evaluation #nielsen #ux
👁 8 views
finance Intermediate

Negotiate a Better Mortgage Rate by Asking the Right Questions

Help me negotiate a better mortgage rate. Inputs: my credit score [N], down paym...

#finance #mortgage #negotiation
👁 8 views
excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup
👁 8 views
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #reconciliation #fuzzy match
👁 7 views
marketing Intermediate

Plan a Week of On-Brand Social Posts

You are a social media strategist. Plan a week of posts for the platform and bra...

#marketing #social-media #content-calendar
👁 7 views
excel Intermediate

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

#excel #variance-analysis #budget
👁 6 views
excel Intermediate

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

#rolling #trend #dynamic-range
👁 6 views
marketing Intermediate

Marketing: Diagnose a Landing Page That Gets Traffic But No Signups

My landing page gets steady traffic but the signup rate is 0.4%. Help me diagnos...

#landing-page #conversion #cro
👁 6 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 6 views
excel Intermediate

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#excel #dashboard #formulas
👁 6 views
excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #power-query #unpivot
👁 6 views
finance Intermediate

Decode a Compensation Offer Beyond the Base Salary

Help me evaluate this comp offer beyond the base number. Offer: base [X], target...

#finance #compensation #equity
👁 5 views
excel Intermediate

Compare Two Excel Sheets and Highlight Real Differences

I need to compare two Excel sheets that should match but probably don't. Sheet A...

#excel #comparison #vlookup
👁 5 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval