Use VLOOKUP or INDEX/MATCH — AI Prompts for Microsoft Excel

The four heights

The same task, four distances: today's deadline, the next reviewer, the stuck moment, the pattern.

Execute — do the immediate task

Match a 3,200-row expense file to our cost center rates on the sheet CostRates using a robust…

Match a 3,200-row expense file to our cost center rates on the sheet CostRates using a robust lookup so every matched row shows the correct rate. Use an INDEX/MATCH solution that tolerates vendor codes stored as numbers in one sheet and text in the other. Put the matched rate into a new column called AppliedRate on the sheet Expenses, and highlight any rows where no match was found so finance can investigate before month-end close. Ladder":"L1"

Improve — make it easier to accept

Before I send the matched file to budgeting, make approvals simple: surface the top five expense…

Before I send the matched file to budgeting, make approvals simple: surface the top five expense categories with the largest applied-rate variance, make the AppliedRate column obvious, and mark rows where the vendor code format differs between Expenses and CostRates. Suggest a fallback formula for near matches (e.g., trim leading zeros) and list the specific rows a reviewer should check. Ladder":"L2"

Decide — diagnose the stuck moment

I ran my lookup to apply cost rates and hundreds of rows return #N/A even though the vendor codes…

My lookup returns #N/A for many rows

I ran my lookup to apply cost rates and hundreds of rows return #N/A even though the vendor codes look identical. The budget owner will hold up sign-off if this isn’t resolved. I don’t know whether the mismatch is whitespace, numeric/text types, or alternate codes in the source system. What should I check in order, and what is the best quick fix that preserves auditability? Ladder":"L5"

Become — change the pattern

Each close I lose time reworking lookups: different systems export vendor codes as text, numbers,…

We repeatedly rework failed lookups before close

Each close I lose time reworking lookups: different systems export vendor codes as text, numbers, or padded codes, and we end up hand-fixing hundreds of rows. Which process changes or small automation can stop this recurring firefight so lookups succeed first time? Give three practical changes I can implement with minimal IT help. Ladder":"L6"

Next to this one

Other spreadsheet work people do in Microsoft Excel.

Use data validation lists Use Goal Seek to solve values Use keyboard shortcuts efficiently Use Power Query to transform data Use precision measuring instruments Validate data entry rules Verify scoring calculations Work in various sectors like academia, nonprofits, industry, or government Write grant proposals and manage budgets Write work-related reports

Every task here came from the work, not from a feature list — which is why the prompts name what you want done and never the button that does it. The tool changes; the work does not.

The rest of the map

Same library, five ways in.

Work Atlasthe whole map, interactive Careers1,949 jobs and their real tasks Soft skillsthe human part of the work Activities500 things people do Prompt Librarybrowse every prompt