Data lookup
Advanced data retrieval in Excel using INDEX and MATCH.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill data-lookupAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
0.5 KB, 100 tokens by cl100k_base, as published. Nobody here has run it
INDEX & MATCH
For a two-dimensional look-up, use INDEX combined with two MATCH functions.
Syntax: =INDEX(data_array, MATCH(row_value, row_range, 0), MATCH(column_value, column_range, 0))
data_array: The range containing the data.row_range: The range containing the row headers.column_range: The range containing the column headers.- The
0argument ensures an exact match.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.