Look up a value to the left
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in B2:B5 to bring in the category for each SKU.
Orders
Starting sheet| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | |
| 3 | SKU-200 | |
| 4 | SKU-300 | |
| 5 | SKU-400 |
Catalog
Starting sheet| A | B | |
|---|---|---|
| 1 | Category | SKU |
| 2 | Hardware | SKU-100 |
| 3 | Software | SKU-200 |
| 4 | Services | SKU-300 |
| 5 | Accessories | SKU-400 |
A passing output
Autosheet in Excel · Opus 5.5B2=IFERROR(INDEX(Catalog!$A$2:$A$6, MATCH(A2, Catalog!$B$2:$B$6, 0)), "Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Pass criteria
All must be met, checked automatically.Orders!B2:B5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
B2=IFERROR(INDEX(Catalog!$A$2:$A$6, MATCH(A2, Catalog!$B$2:$B$6, 0)), "Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Excel GPT-6 Astra · Low
B2=XLOOKUP(A2,Catalog!$B$2:$B$5,Catalog!$A$2:$A$5,"Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Sheets Opus 5.5 · Medium
B2=IFERROR(INDEX(Catalog!$A$2:$A$5, MATCH(A2, Catalog!$B$2:$B$5, 0)), "Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Excel Sonnet 5.5 · Medium
B2=INDEX(Catalog!$A$2:$A$6,MATCH(A2,Catalog!$B$2:$B$6,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude in Excel Opus 5.5 · High
B2=INDEX(Catalog!$A:$A,MATCH(A2,Catalog!$B:$B,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Excel Haiku 5.5 · High
B2=XLOOKUP(A2,Catalog!$B:$B,Catalog!$A:$A,"Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude in Sheets Opus 5.5 · Medium
B2=IFERROR(INDEX(Catalog!$A$2:$A$5,MATCH($A2,Catalog!$B$2:$B$5,0)),"Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude Code + Sheets MCP Opus 5.5 · Medium
B2=INDEX(Catalog!$A:$A, MATCH(A2, Catalog!$B:$B, 0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Excel GPT-6.1 Sol · Medium
B2=XLOOKUP(A2,Catalog!$B$2:$B$5,Catalog!$A$2:$A$5,"")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude Code + Autosheet MCP Opus 5.5 · Medium
B2=XLOOKUP(A2, Catalog!$B$2:$B1000, Catalog!$A$2:$A1000, "Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT + Autosheet MCP GPT-6 · Medium
B2=INDEX(Catalog!$A$2:$A$5, MATCH(A2, Catalog!$B$2:$B$5, 0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Sheets Haiku 5.5 · High
B2=XLOOKUP(A2,Catalog!$B:$B,Catalog!$A:$A,"Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT in Excel GPT-6 Astra · Medium
B2=INDEX(Catalog!$A$2:$A$5,MATCH(A2,Catalog!$B$2:$B$5,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude in Excel Haiku 5.5 · High
B2=INDEX(Catalog!$A:$A,MATCH(A2,Catalog!$B:$B,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Claude in Sheets Haiku 5.5 · High
B2=INDEX(Catalog!$A$2:$A$5, MATCH(A2, Catalog!$B$2:$B$5, 0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Autosheet in Excel GPT-6 Luna · High
B2=INDEX(Catalog!$A:$A,MATCH(A2,Catalog!$B:$B,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Copilot in Excel Auto
B2=XLOOKUP(A2,Catalog!$B$2:$B$5,Catalog!$A$2:$A$5,"Not found")
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT + Drive MCP GPT-6 · Medium
B2=INDEX(Catalog!$A$2:$A$5,MATCH(A2,Catalog!$B$2:$B$5,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT in Excel GPT-6 Luna · High
B2=XLOOKUP(A2,Catalog!$B$2:$B$5,Catalog!$A$2:$A$5)
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
Gemini in Sheets Auto
B2=INDEX(Catalog!$A$2:$A$5, MATCH(A2, Catalog!$B$2:$B$5, 0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT in Sheets GPT-6 Astra · Medium
B2=INDEX(Catalog!$A$2:$A$5,MATCH(A2,Catalog!$B$2:$B$5,0))
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |
ChatGPT in Sheets GPT-6 Luna · High
B2=XLOOKUP(A2,Catalog!$B$2:$B$5,Catalog!$A$2:$A$5)
| A | B | |
|---|---|---|
| 1 | SKU | Category |
| 2 | SKU-100 | Hardware |
| 3 | SKU-200 | Software |
| 4 | SKU-300 | Services |
| 5 | SKU-400 | Accessories |