agentsclimarketplace
Sign in

Run2 excel lookup

Skill cxcscmu/SkillLearnBench/skills/b2-self-feedback-gemini-3.1-pro-preview/weighted-gdp-calculation/run2_excel-lookup

How to perform a two-dimensional lookup in Excel using either INDEX/MATCH or VLOOKUP/MATCH.From its SKILL.md

Install
npx -y skills add cxcscmu/SkillLearnBench --skill run2_excel-lookup

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

0.7 KB, 165 tokens by cl100k_base, as published. Nobody here has run it

Advanced Excel Lookups

When dealing with a matrix of data (e.g., country rows and year columns), you must look up data using both vertical and horizontal criteria.

Option 1: INDEX & MATCH

This is the most flexible approach.

=INDEX(Data!$A$21:$Z$40, MATCH($D12, Data!$B$21:$B$40, 0), MATCH(H$9, Data!$A$4:$Z$4, 0))
  • Data!$A$21:$Z$40: The full grid to return a value from.
  • First MATCH: Finds the relative row by matching the code in column B.
  • Second MATCH: Finds the relative column by matching the year in row 4.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.