agentsclimarketplace
Sign in

Run3 Data Retrieval using INDEX and MATCH

Skill cxcscmu/SkillLearnBench/skills/b3-teacher-feedback-gemini-3.1-flash-lite-preview/weighted-gdp-calculation/run3_Data-Retrieval-using-INDEX-and-MATCH

Use INDEX combined with MATCH to retrieve data from a source table based on two criteria (row and column headers).From its SKILL.md

Install
npx -y skills add cxcscmu/SkillLearnBench --skill run3_Data-Retrieval-using-INDEX-and-MATCH

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, 157 tokens by cl100k_base, as published. Nobody here has run it

To retrieve data from the 'Data' sheet into the 'Task' sheet:

  1. Use the formula: =INDEX(Data!$E$21:$Z$40, MATCH($D12, Data!$D$21:$D$40, 0), MATCH(H$10, Data!$E$20:$Z$20, 0)).
  2. Ensure the row index (column D) and column index (year header in row 10) are locked appropriately with $ signs to allow dragging across the target ranges (H12:L17, H19:L24, and H26:L31).
  3. Verify that the array range Data!$E$21:$Z$40 exactly matches the source data bounds specified in the requirements.

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.