Look up a value by row and column
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use a formula in G4 to return the value for the row label in G2 and column header in G3.
Starting spreadsheet
Lookup| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result |
A passing output
Autosheet in Excel · Opus 5.5G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Pass criteria
All must be met, checked automatically.G4is 110G4uses a formula
Passed 22
Autosheet in Excel Opus 5.5 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Excel GPT-6 Astra · Low
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Sheets Opus 5.5 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Excel Sonnet 5.5 · Medium
G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude in Excel Opus 5.5 · High
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Excel Haiku 5.5 · High
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude in Sheets Opus 5.5 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude Code + Sheets MCP Opus 5.5 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Excel GPT-6.1 Sol · Medium
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT + Autosheet MCP GPT-6 · Medium
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Sheets Haiku 5.5 · High
G4=INDEX($B$2:$D$4, MATCH(G2, $A$2:$A$4, 0), MATCH(G3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT in Excel GPT-6 Astra · Medium
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude in Excel Haiku 5.5 · High
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Claude in Sheets Haiku 5.5 · High
G4=INDEX($B$2:$D$4, MATCH($G$2, $A$2:$A$4, 0), MATCH($G$3, $B$1:$D$1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Autosheet in Excel GPT-6 Luna · High
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Copilot in Excel Auto
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT + Drive MCP GPT-6 · Medium
G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT in Excel GPT-6 Luna · High
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
Gemini in Sheets Auto
G4=INDEX(A1:D4, MATCH(G2, A1:A4, 0), MATCH(G3, A1:D1, 0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT in Sheets GPT-6 Astra · Medium
G4=INDEX($B$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(G3,$B$1:$D$1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |
ChatGPT in Sheets GPT-6 Luna · High
G4=INDEX(B2:D4,MATCH(G2,A2:A4,0),MATCH(G3,B1:D1,0))
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Input | Value | |
| 2 | North | 120 | 135 | 142 | Row label | Europe | |
| 3 | Europe | 98 | 110 | 127 | Column header | Q2 | |
| 4 | Asia | 145 | 151 | 166 | Result | 110 |