All AutosheetBench tasks

Look up a value by row and column

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use a formula in G4 to return the value for the row label in G2 and column header in G3.

Starting spreadsheet

Lookup
ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result

A passing output

Autosheet in Excel · Opus 5.5
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • G4 is 110
  • G4 uses a formula

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed7s · 2¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Excel GPT-6 Astra · Low

Passed6s · 5¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Sheets Opus 5.5 · Medium

Passed14s · 2¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 0.8¢
Lookup1 cell changed

G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude in Excel Opus 5.5 · High

Passed7s · 6¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Excel Haiku 5.5 · High

Passed5s · 0.1¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude in Sheets Opus 5.5 · Medium

Passed13s · 3¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed21s · N/A
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Excel GPT-6.1 Sol · Medium

Passed9s · 2¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed31s · N/A
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed26s · N/A
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Sheets Haiku 5.5 · High

Passed11s · 0.1¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT in Excel GPT-6 Astra · Medium

Passed15s · 39¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude in Excel Haiku 5.5 · High

Passed5s · 0.3¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Claude in Sheets Haiku 5.5 · High

Passed11s · 0.3¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4, MATCH($G$2, $A$2:$A$4, 0), MATCH($G$3, $B$1:$D$1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Autosheet in Excel GPT-6 Luna · High

Passed5s · 0.1¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Copilot in Excel Auto

Passed14s · N/A
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT + Drive MCP GPT-6 · Medium

Passed21s · N/A
Lookup1 cell changed

G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT in Excel GPT-6 Luna · High

Passed16s · 0.4¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

Gemini in Sheets Auto

Passed39s · N/A
Lookup1 cell changed

G4=INDEX(A1:D4, MATCH(G2, A1:A4, 0), MATCH(G3, A1:D1, 0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT in Sheets GPT-6 Astra · Medium

Passed20s · 31¢
Lookup1 cell changed

G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110

ChatGPT in Sheets GPT-6 Luna · High

Passed17s · 0.3¢
Lookup1 cell changed

G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))

ABCDEFG
1RegionQ1Q2Q3InputValue
2North120135142Row labelEurope
3Europe98110127Column headerQ2
4Asia145151166Result110