INDEX & MATCH for Two-Condition Lookups in Excel
SkillFiles & storageUsing INDEX/MATCH formulas in Excel for two-condition lookups across sheets.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the INDEX & MATCH for Two-Condition Lookups in Excel skill
What this skill tells your AI
The instructions your AI receives, as published by cxcscmu/skilllearnbench in skills/b1-one-shot-claude-opus-4-6/weighted-gdp-calculation/excel-index-match/SKILL.md and read by ahel’s review.
Pattern: Cross-Sheet Lookup with Two Criteria
When you need to look up a value using both a row identifier and a column identifier (e.g., series code + year), use INDEX/MATCH:
=INDEX(DataRange, MATCH(RowCriteria, RowLookupRange, 0), MATCH(ColCriteria, ColLookupRange, 0))
Example
Given a Data sheet with series codes in column B and years in row 4:
=INDEX(Data!$H$21:$M$40, MATCH($D12, Data!$B$21:$B$40, 0), MATCH(H$9, Data!$H$4:$M$4, 0))
Key Points
- Use
$to lock ranges that shouldn't shift when copying formulas - Lock row criteria column with
$D12(column locked, row relative) - Lock year row with
H$9(column relative, row locked) - The third argument
0means exact match - INDEX range and MATCH ranges must align (same rows/columns)
Openpyxl Implementation
# When writing INDEX/MATCH formulas via openpyxl, use string assignment:
ws['H12'] = '=INDEX(Data!$H$21:$M$40,MATCH($D12,Data!$B$21:$B$40,0),MATCH(H$9,Data!$H$4:$M$4,0))'
Signals
- GitHub stars
- 83
- Forks
- 5
- Last commit
- Jul 2026
Advanced
- Catalog kind
- skill
- Gateway key
excel-index-match- Source
- github.com/cxcscmu/skilllearnbench