Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add Bwkyd/wps-skills --skill wps-vlookupgit clone --depth 1 https://github.com/Bwkyd/wps-skillsWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/bwkyd/wps-skills/wps-vlookup)<a href="https://agentmods.dev/skills/bwkyd/wps-skills/wps-vlookup"><img src="https://agentmods.dev/badge/skills/bwkyd/wps-skills/wps-vlookup/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/bwkyd/wps-skills/wps-vlookup"><img src="https://agentmods.dev/badge/skills/bwkyd/wps-skills/wps-vlookup.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00081 | $0.02021 |
| Opus 5 | $0.00041 | $0.01010 |
| Sonnet 5 | $0.00016 | $0.00404 |
| Haiku 4.5 | $0.00008 | $0.00202 |
Grade A, and why
wps-vlookup scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 11d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 230 lines — stays where its author put it; the contents beside it link to each section on GitHub.
VLOOKUP/查找匹配专家
解决WPS表格中最高频的痛点 — 数据查找与匹配。
据统计，VLOOKUP相关问题占WPS求助帖的35%以上。
When to Use
- 需要从一张表查找另一张表的数据
- VLOOKUP返回#N/A、#REF!等错误
- 需要多条件查找/反向查找/多列返回
- 用户说"帮我写个VLOOKUP""两张表怎么关联"
When NOT to Use
- 通用公式问题 → 使用
wps-formula - 数据透视分析 → 使用
wps-pivot
查找场景速查
场景1：基础正向查找（最常见）
需求：根据工号查姓名
公式：=VLOOKUP(A2, 员工表!A:C, 3, FALSE)
参数解释：
A2 → 要查找的值（工号）
员工表!A:C → 查找范围（工号在第1列）
3 → 返回第3列（姓名）
FALSE → 精确匹配（99%的情况用FALSE）
场景2：反向查找（VLOOKUP做不到）
需求：根据姓名查工号（姓名在右边，工号在左边）
方案A - INDEX+MATCH（推荐）：
=INDEX(A:A, MATCH(D2, C:C, 0))
方案B - XLOOKUP（WPS 2021+）：
=XLOOKUP(D2, C:C, A:A)
场景3：多条件查找
需求：根据"部门+姓名"查找工资
方案 - INDEX+MATCH+数组：
=INDEX(C:C, MATCH(1, (A:A=E2)*(B:B=F2), 0))
（Ctrl+Shift+Enter 数组公式）
方案 - 辅助列：
辅助列公式：=A2&"|"&B2
然后VLOOKUP查找 E2&"|"&F2
场景4：模糊匹配/近似查找
需求：根据成绩查等级（60→及格，80→良好，90→优秀）
公式：=VLOOKUP(A2, 等级表, 2, TRUE)
注意：等级表第一列必须升序排列！
等级表：
0 不及格
60 及格
80 良好
90 优秀
场景5：跨工作簿查找
=VLOOKUP(A2, '[数据源.xlsx]Sheet1'!A:D, 3, FALSE)
注意：源文件必须打开，否则需要写完整路径
场景6：一次返回多列
需求：查找后返回多个字段
方案 - VLOOKUP+COLUMN：
=VLOOKUP($A2, 数据!$A:$F, COLUMN(B1), FALSE)
向右拖动自动递增列号
方案 - XLOOKUP返回数组（WPS 2021+）：
=XLOOKUP(A2, 数据!A:A, 数据!B:F)
一次返回B到F所有列
#N/A 错误诊断
VLOOKUP返回#N/A？按这个顺序排查：
1️⃣ 数据类型不一致（最常见！）
症状：明明有这个值但就是找不到
原因：查找值是文本"001"，表里是数字1
修复：=VLOOKUP(VALUE(A2), ...) 或 =VLOOKUP(TEXT(A2,"000"), ...)
2️⃣ 有隐藏空格
症状：肉眼看一样但匹配不上
检测：=LEN(A2) 看长度是否异常
修复：=VLOOKUP(TRIM(CLEAN(A2)), ...)
3️⃣ 查找列不在第一列
症状：范围选错了
修复：调整范围让查找值在第一列，或改用INDEX+MATCH
4️⃣ 第4参数写了TRUE或省略
症状：返回错误的值
修复：改为FALSE（精确匹配）
5️⃣ 查找范围有合并单元格
症状：只有合并区域第一行能匹配
修复：先取消合并 → 填充空值 → 再查找
工作流程
Step 1: 理解查找需求
确认以下信息：
- 查找什么：用什么值去查（如工号、姓名）
- 从哪里查：数据源在哪个表/文件
- 返回什么：需要取回哪些字段
- 特殊要求：多条件？模糊匹配？反向？
Step 2: 选择最佳方案
┌─ 正向查找（查找列在最左）
│ └─ 单条件 → VLOOKUP
│ └─ 多条件 → 辅助列+VLOOKUP 或 INDEX+MATCH
│
├─ 反向查找（查找列在右侧）
│ └─ INDEX+MATCH 或 XLOOKUP
│
├─ 多列返回
│ └─ VLOOKUP+COLUMN 或 XLOOKUP
│
└─ 近似/区间匹配
└─ VLOOKUP(TRUE) 或 IFS
What ships with it
1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 11d ago First seen · 230 lines · 81 tokens per session scan A 925746930f02
wps-vlookup is a skill published in the GitHub repository Bwkyd/wps-skills (7 stars, last pushed 4mo ago), licensed MIT. It adds 81 tokens to every session and 2,021 once invoked, about $0.0004 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other skills, from other repositories
xlsx
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or…
xlsx
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the workbook file is the primary deliverable. Use for formulas, formatting, financial models, multi-sheet workbooks, and tabular cleanup exported to Excel. Also applies to .csv/.tsv when the user wants spreadsheet output. Do NOT use for…
document-generation
Generate Word (.docx), Excel (.xlsx) and PowerPoint (.pptx) documents and fill existing PDF forms, from real NetClaw data, with per-element provenance and no fabrication. Use when someone needs a deliverable rather than an answer — a change record to attach to a CR, an audit workbook for a compliance reviewer, a…
google-sheets
Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Use when user asks to: read a spreadsheet, update cells, add data to Google Sheets, find a spreadsheet, check sheet contents, export spreadsheet data, or get cell…
dgn-to-excel
Convert DGN files (v7-v8) to Excel databases. Extract elements, levels, and properties from infrastructure CAD files.
dwg-to-excel
Convert AutoCAD DWG files (1983-2026) to Excel databases using DwgExporter CLI. Extract layers, blocks, attributes, and geometry data without Autodesk licenses.