Look up prices and compute totals
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in C2:D16 to pull prices from the catalog and calculate each total.
Orders
Starting sheet| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | ||
| 3 | PRD-117 | 1 | ||
| 4 | PRD-308 | 5 | ||
| 5 | PRD-452 | 2 | ||
| 6 | PRD-204 | 7 | ||
| 7 | PRD-117 | 4 | ||
| 8 | PRD-561 | 6 | ||
| 9 | PRD-308 | 2 | ||
| 10 | PRD-452 | 3 | ||
| 11 | PRD-789 | 1 | ||
| 12 | PRD-204 | 8 | ||
| 13 | PRD-117 | 2 | ||
| 14 | PRD-561 | 5 | ||
| 15 | PRD-789 | 4 | ||
| 16 | PRD-308 | 3 |
Catalog
Starting sheet| A | B | |
|---|---|---|
| 1 | ProductID | UnitPrice |
| 2 | PRD-117 | 12.5 |
| 3 | PRD-204 | 8.75 |
| 4 | PRD-308 | 22 |
| 5 | PRD-452 | 5.4 |
| 6 | PRD-561 | 31 |
| 7 | PRD-623 | 18.25 |
| 8 | PRD-789 | 9.99 |
| 9 | PRD-844 | 44.5 |
A passing output
Autosheet in Excel · Opus 5.5C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Pass criteria
All must be met, checked automatically.Orders!C2:D16hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Autosheet in Excel GPT-6 Astra · Low
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Autosheet in Sheets Opus 5.5 · Medium
C2=XLOOKUP(A2, Catalog!$A$2:$A$9, Catalog!$B$2:$B$9, "Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | $8.75 | $26.25 |
| 3 | PRD-117 | 1 | $12.50 | $12.50 |
| 4 | PRD-308 | 5 | $22.00 | $110.00 |
| 5 | PRD-452 | 2 | $5.40 | $10.80 |
| 6 | PRD-204 | 7 | $8.75 | $61.25 |
| 7 | PRD-117 | 4 | $12.50 | $50.00 |
| 8 | PRD-561 | 6 | $31.00 | $186.00 |
| 9 | PRD-308 | 2 | $22.00 | $44.00 |
| 10 | PRD-452 | 3 | $5.40 | $16.20 |
| 11 | PRD-789 | 1 | $9.99 | $9.99 |
| 12 | PRD-204 | 8 | $8.75 | $70.00 |
| 13 | PRD-117 | 2 | $12.50 | $25.00 |
| 14 | PRD-561 | 5 | $31.00 | $155.00 |
| 15 | PRD-789 | 4 | $9.99 | $39.96 |
| 16 | PRD-308 | 3 | $22.00 | $66.00 |
Autosheet in Excel Sonnet 5.5 · Medium
C2=XLOOKUP(A2,Catalog!$A$2:$A$10,Catalog!$B$2:$B$10,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Claude in Excel Opus 5.5 · High
C2=XLOOKUP(A2,Catalog!$A:$A,Catalog!$B:$B,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.50 | 12.50 |
| 4 | PRD-308 | 5 | 22.00 | 110.00 |
| 5 | PRD-452 | 2 | 5.40 | 10.80 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.50 | 50.00 |
| 8 | PRD-561 | 6 | 31.00 | 186.00 |
| 9 | PRD-308 | 2 | 22.00 | 44.00 |
| 10 | PRD-452 | 3 | 5.40 | 16.20 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70.00 |
| 13 | PRD-117 | 2 | 12.50 | 25.00 |
| 14 | PRD-561 | 5 | 31.00 | 155.00 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22.00 | 66.00 |
Autosheet in Excel Haiku 5.5 · High
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Claude in Sheets Opus 5.5 · Medium
C2=XLOOKUP(A2,Catalog!$A$2:$A1000,Catalog!$B$2:$B1000)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | $8.75 | $26.25 |
| 3 | PRD-117 | 1 | $12.50 | $12.50 |
| 4 | PRD-308 | 5 | $22.00 | $110.00 |
| 5 | PRD-452 | 2 | $5.40 | $10.80 |
| 6 | PRD-204 | 7 | $8.75 | $61.25 |
| 7 | PRD-117 | 4 | $12.50 | $50.00 |
| 8 | PRD-561 | 6 | $31.00 | $186.00 |
| 9 | PRD-308 | 2 | $22.00 | $44.00 |
| 10 | PRD-452 | 3 | $5.40 | $16.20 |
| 11 | PRD-789 | 1 | $9.99 | $9.99 |
| 12 | PRD-204 | 8 | $8.75 | $70.00 |
| 13 | PRD-117 | 2 | $12.50 | $25.00 |
| 14 | PRD-561 | 5 | $31.00 | $155.00 |
| 15 | PRD-789 | 4 | $9.99 | $39.96 |
| 16 | PRD-308 | 3 | $22.00 | $66.00 |
Claude Code + Sheets MCP Opus 5.5 · Medium
C2=INDEX(Catalog!$B:$B,MATCH($A2,Catalog!$A:$A,0))
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Autosheet in Excel GPT-6.1 Sol · Medium
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
C2=IFERROR(XLOOKUP(TRIM(A2), Catalog!$A$2:$A$9, Catalog!$B$2:$B$9), "Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
ChatGPT + Autosheet MCP GPT-6 · Medium
C2=XLOOKUP(TRIM($A2), Catalog!$A$2:$A$9, Catalog!$B$2:$B$9, "Not found", 0)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Autosheet in Sheets Haiku 5.5 · High
C2=XLOOKUP(A2,Catalog!$A:$A,Catalog!$B:$B,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
ChatGPT in Excel GPT-6 Astra · Medium
C2=VLOOKUP(A2,Catalog!$A$2:$B$9,2,FALSE)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Claude in Excel Haiku 5.5 · High
C2=INDEX(Catalog!$B$2:$B$9,MATCH(A2,Catalog!$A$2:$A$9,0))
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.50 | 12.50 |
| 4 | PRD-308 | 5 | 22.00 | 110.00 |
| 5 | PRD-452 | 2 | 5.40 | 10.80 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.50 | 50.00 |
| 8 | PRD-561 | 6 | 31.00 | 186.00 |
| 9 | PRD-308 | 2 | 22.00 | 44.00 |
| 10 | PRD-452 | 3 | 5.40 | 16.20 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70.00 |
| 13 | PRD-117 | 2 | 12.50 | 25.00 |
| 14 | PRD-561 | 5 | 31.00 | 155.00 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22.00 | 66.00 |
Claude in Sheets Haiku 5.5 · High
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.50 | 12.50 |
| 4 | PRD-308 | 5 | 22.00 | 110.00 |
| 5 | PRD-452 | 2 | 5.40 | 10.80 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.50 | 50.00 |
| 8 | PRD-561 | 6 | 31.00 | 186.00 |
| 9 | PRD-308 | 2 | 22.00 | 44.00 |
| 10 | PRD-452 | 3 | 5.40 | 16.20 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70.00 |
| 13 | PRD-117 | 2 | 12.50 | 25.00 |
| 14 | PRD-561 | 5 | 31.00 | 155.00 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22.00 | 66.00 |
Autosheet in Excel GPT-6 Luna · High
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9,"Not found")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Copilot in Excel Auto
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.50 | 12.50 |
| 4 | PRD-308 | 5 | 22.00 | 110.00 |
| 5 | PRD-452 | 2 | 5.40 | 10.80 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.50 | 50.00 |
| 8 | PRD-561 | 6 | 31.00 | 186.00 |
| 9 | PRD-308 | 2 | 22.00 | 44.00 |
| 10 | PRD-452 | 3 | 5.40 | 16.20 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70.00 |
| 13 | PRD-117 | 2 | 12.50 | 25.00 |
| 14 | PRD-561 | 5 | 31.00 | 155.00 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22.00 | 66.00 |
ChatGPT + Drive MCP GPT-6 · Medium
C2=XLOOKUP(A2,Catalog!$A$2:$A$9,Catalog!$B$2:$B$9,"")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
ChatGPT in Excel GPT-6 Luna · High
C2=VLOOKUP(A2,Catalog!$A$2:$B$10,2,FALSE)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
Gemini in Sheets Auto
C2=XLOOKUP(A2, Catalog!$A$2:$A$9, Catalog!$B$2:$B$9)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | $8.75 | $26.25 |
| 3 | PRD-117 | 1 | $12.50 | $12.50 |
| 4 | PRD-308 | 5 | $22.00 | $110.00 |
| 5 | PRD-452 | 2 | $5.40 | $10.80 |
| 6 | PRD-204 | 7 | $8.75 | $61.25 |
| 7 | PRD-117 | 4 | $12.50 | $50.00 |
| 8 | PRD-561 | 6 | $31.00 | $186.00 |
| 9 | PRD-308 | 2 | $22.00 | $44.00 |
| 10 | PRD-452 | 3 | $5.40 | $16.20 |
| 11 | PRD-789 | 1 | $9.99 | $9.99 |
| 12 | PRD-204 | 8 | $8.75 | $70.00 |
| 13 | PRD-117 | 2 | $12.50 | $25.00 |
| 14 | PRD-561 | 5 | $31.00 | $155.00 |
| 15 | PRD-789 | 4 | $9.99 | $39.96 |
| 16 | PRD-308 | 3 | $22.00 | $66.00 |
ChatGPT in Sheets GPT-6 Astra · Medium
C2=VLOOKUP(A2,Catalog!$A$2:$B$9,2,FALSE)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |
ChatGPT in Sheets GPT-6 Luna · High
C2=INDEX(Catalog!$B$2:$B$9,MATCH(A2,Catalog!$A$2:$A$9,0))
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ProductID | Quantity | Price | Total |
| 2 | PRD-204 | 3 | 8.75 | 26.25 |
| 3 | PRD-117 | 1 | 12.5 | 12.5 |
| 4 | PRD-308 | 5 | 22 | 110 |
| 5 | PRD-452 | 2 | 5.4 | 10.8 |
| 6 | PRD-204 | 7 | 8.75 | 61.25 |
| 7 | PRD-117 | 4 | 12.5 | 50 |
| 8 | PRD-561 | 6 | 31 | 186 |
| 9 | PRD-308 | 2 | 22 | 44 |
| 10 | PRD-452 | 3 | 5.4 | 16.2 |
| 11 | PRD-789 | 1 | 9.99 | 9.99 |
| 12 | PRD-204 | 8 | 8.75 | 70 |
| 13 | PRD-117 | 2 | 12.5 | 25 |
| 14 | PRD-561 | 5 | 31 | 155 |
| 15 | PRD-789 | 4 | 9.99 | 39.96 |
| 16 | PRD-308 | 3 | 22 | 66 |