excel-lookup-functions

excel-lookup-functions is a skill for Claude Code, Codex from cxcscmu/SkillLearnBench. It costs 32 tokens per session (1,025 once invoked), scanned A, original, MIT.

A guide to Excel lookup formulas, which find a value in a table and return related information. It covers VLOOKUP, HLOOKUP, INDEX/MATCH, and XLOOKUP, including multiple criteria.

In plain words
What is it for?
Build spreadsheet formulas that look up records in vertical or horizontal tables and handle more flexible matching.
Why use it?
It helps retrieve matching data without searching tables manually or writing custom code.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Install

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.

agentmods
npx agentmods add skills/cxcscmu/skilllearnbench/excel-lookup-functions
Any agent
npx skills add cxcscmu/SkillLearnBench --skill excel-lookup-functions
Clone the repo
git clone --depth 1 https://github.com/cxcscmu/SkillLearnBench

Made for: Claude Code, Codex.

Wrote 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.

agentmods badge for excel-lookup-functions

README.md
[![agentmods](https://agentmods.dev/badge/skills/cxcscmu/skilllearnbench/excel-lookup-functions.svg)](https://agentmods.dev/skills/cxcscmu/skilllearnbench/excel-lookup-functions)
Your own site
<a href="https://agentmods.dev/skills/cxcscmu/skilllearnbench/excel-lookup-functions"><img src="https://agentmods.dev/badge/skills/cxcscmu/skilllearnbench/excel-lookup-functions.svg" alt="Measured on agentmods" height="20"></a>
Per session 32 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,025 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00032 $0.01025
Opus 5 $0.00016 $0.00513
Sonnet 5 $0.00006 $0.00205
Haiku 4.5 $0.00003 $0.00103

Measured 2d ago against content hash cc8ac7851a6a, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-05, from the pricing page.

Security

Grade A, and why

excel-lookup-functions 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 2d 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.

skills/b1-one-shot-claude-haiku-4-5/weighted-gdp-calculation/excel-lookup-functions/SKILL.md · 136 lines

How it starts

The opening of the file, as written. The whole thing — 136 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Excel Lookup Functions

Overview

Lookup functions allow you to find and retrieve data from tables based on criteria. Different functions suit different scenarios.

Function Comparison

VLOOKUP (Vertical Lookup)

Searches for a value in the first column of a range and returns a value in the same row from another column.

Syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Limitations:

  • Can only search in the first column
  • Lookup column must be to the left of return column
  • Cannot handle multiple criteria easily

Example:

=VLOOKUP("Series_A", Data!A:D, 3, FALSE)

HLOOKUP (Horizontal Lookup)

Searches for a value in the first row of a range and returns a value in the same column from another row.

Syntax:

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Use Case: When data is organized horizontally with lookup values in the top row.

Example:

=HLOOKUP(2020, Data!A1:F10, 3, FALSE)

INDEX & MATCH (Flexible Lookup)

INDEX returns a value from a specific position in a range. MATCH finds the position of a value.

Syntax:

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Advantages:

  • Works with data in any position
  • Can be modified for multiple criteria
  • More flexible than VLOOKUP

Example (Single Criterion):

=INDEX(Data!$C$1:$C$100, MATCH("Series_A", Data!$A$1:$A$100, 0))

Example (Multiple Criteria):

=INDEX(Data!$E$1:$E$100, MATCH(1, (Data!$A$1:$A$100=criteria1)*(Data!$B$1:$B$100=criteria2), 0))

Note: This requires Ctrl+Shift+Enter (array formula) in traditional Excel.

XLOOKUP (Modern Solution)

Available in Excel 365 and newer versions. Combines benefits of VLOOKUP and INDEX/MATCH.

Syntax:

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Advantages:

  • Simpler syntax than INDEX/MATCH
  • Can search left or right
  • Built-in error handling
  • Native support for multiple criteria

Read the full file on GitHub · 136 lines

Changes

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.

  1. 2d ago First seen · 136 lines · 32 tokens per session scan A cc8ac7851a6a

Subscribe to this mod's changes

excel-lookup-functions is a skill published in the GitHub repository cxcscmu/SkillLearnBench (83 stars, last pushed 1mo ago), licensed MIT. It adds 32 tokens to every session and 1,025 once invoked, about $0.0002 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-09-03.

Related

Other skills, from other repositories

xlsx-parsing

Read Microsoft Excel (.xlsx) files robustly with openpyxl (or pandas). Covers multi-sheet workbooks, header rows, empty cells, merged cells, comma-separated list cells, and converting a sheet to a list-of-dicts the rest of your code can consume. Use when a task input or reference document is an .xlsx file rather than…

benchflow-ai/skillsbench · 83 tokens

data-formats

Reading, writing, and converting common data formats (CSV, Excel, JSON, YAML) with correct handling of encoding, types, and edge cases.

A-EVO-Lab/a-evolve · 34 tokens

xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify…

benchflow-ai/benchflow · 96 tokens

xlsx

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify…

benchflow-ai/skillsbench · 96 tokens

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…

ECNU-ICALK/AutoSkill · 201 tokens

TypeScript 인터페이스 순서 기반 xlsx 엑셀 다운로드 구현

사용자가 정의한 TypeScript 인터페이스의 속성 순서를 기준으로 데이터 배열을 변환하고, xlsx 라이브러리를 사용하여 엑셀 파일로 다운로드하는 함수를 작성합니다.

ECNU-ICALK/AutoSkill · 59 tokens