kesslernity/awesome-copilot-office-skills / skills/lookup-integrity-check
lookup-integrity-check
VerifiedChecks every lookup in the open workbook for the faults that return a wrong row rather than an error: approximate match left on by default, duplicate keys on the lookup side, keys that exist in one table and not the other, mismatched types, and ranges that shift when rows are inserted. Changes nothing. Use when the user asks to check lookups, joins, references between tables, or why two sheets disagree.
README.md
View on GitHub# Lookup integrity check
> Checks every lookup for approximate match, duplicate keys, unmatched keys and type mismatches. Changes nothing.
## What it produces
See the Output section of [SKILL.md](SKILL.md). Every output is a draft: the skill stops at a human approval checkpoint before it changes anything.
## Install in 60 seconds
1. Download `dist/personal/lookup-integrity-check.zip` from this repository, or copy this folder.
2. In Excel, open Copilot, select **Settings**, then **Manage plugins & skills**, then **Custom skills**, then **Create OneDrive folder** and **Open skills folder**. Place the `lookup-integrity-check` folder inside, then select **Refresh**. Your Office display language must be set to English, or skills do not appear.
3. Type `@lookup-integrity-check` in the Copilot prompt, followed by your request.
Other tools: see [runtimes/](../../runtimes/).
## Example triggers
- "Why do these two sheets disagree?"
- "Check my lookups for duplicate keys"
- "Which keys are missing from the mapping table?"
## Complements, does not duplicate
Complements clean-data: examines the joins rather than the values.
## Status
Format-validated by `scripts/validate` on 2026-10-24. Tested in a live Excel tenant: pending. Report results with the tenant behaviour issue template.
## Changelog
| Version | Date | Change |
|---|---|---|
| 1.0 | 2026-10-24 | Initial version |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |