Spreadsheets
Excel, Google Sheets, Numbers. Crade reads the cells on your screen and tells you the formula, the steps, or the exact menu path. Less time on Stack Overflow, more time on the actual data.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Qty | Rate | Total |
| 2 | Laptop Pro M4 | 2 | $1499 | $2,998 |
| 3 | USB-C Hub | 5 | $49 | $245 |
| 4 | Monitor 27" | 3 | $399 | $1,197 |
| 5 | Mech Keyboard | 4 | $129 | $516 |
| 6 | Wireless Mouse | 8 | $59 | $472 |
| 7 | Webcam HD | 3 | $89 | $267 |
| 8 | Subtotal | $5,695 |
Give me a formula for D2 that looks up the rate for the Item in column A from the Rates tab.
Use XLOOKUP (modern, cleanest): =XLOOKUP(A2, Rates!A:A, Rates!B:B, 0) If your sheet does not have XLOOKUP, INDEX/MATCH works: =INDEX(Rates!B:B, MATCH(A2, Rates!A:A, 0)) Both return 0 if not found instead of #N/A. Drag the formula down column D — relative references update for each row.
Get any spreadsheet formula in one prompt with Crade
VLOOKUP, INDEX/MATCH, pivot tables, conditional formatting. Crade reads your spreadsheet on screen and gives you the exact formula, no Stack Overflow detour.
| Date | Region | Rev |
|---|---|---|
| Apr 12 | EMEA | 14,200 |
| Apr 18 | APAC | 8,700 |
| Apr 24 | AMER | 21,300 |
| May 03 | EMEA | 16,800 |
| May 11 | AMER | 19,500 |
| May 22 | APAC | 11,400 |
| Jun 02 | EMEA | 17,900 |
| Jun 09 | AMER | 24,600 |
| Jun 14 | APAC | 9,800 |
| Month | EMEA | APAC | AMER | Total |
|---|---|---|---|---|
| April | 14,200 | 8,700 | 21,300 | 44,200 |
| May | 16,800 | 11,400 | 19,500 | 47,700 |
| June | 17,900 | 9,800 | 24,600 | 52,300 |
| Total | 48,900 | 29,900 | 65,400 | 144,200 |
Build me a pivot table that shows revenue by month by region, with totals.
Pivot setup for Numbers: Rows: Date (group by month) Columns: Region Values: Revenue (sum) In Numbers: 1. Click any cell in your data 2. Organize . Pivot Table . New Pivot Table 3. Drag Date to Rows, Region to Columns, Revenue to Values 4. Right-click the date column . Group by . Month Totals appear automatically in the rightmost column and bottom row.
Build a pivot table from any data with Crade
Pivot tables are powerful but unintuitive. Crade reads your raw data on screen and tells you exactly which fields to drag where, in plain language, for Excel or Sheets.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Qty | Rate | Total |
| 2 | Laptop Pro M4 | 2 | $1499 | $2,998 |
| 3 | USB-C Hub | 5 | $49 | $245 |
| 4 | Monitor 27" | 3 | $399 | $1,197 |
| 5 | Mech Keyboard | 4 | $129 | $516 |
| 6 | Wireless Mouse | 8 | $59 | $472 |
| 7 | Webcam HD | 3 | $89 | $267 |
| 8 | Subtotal | $5,695 |
Give me a formula for D2 that looks up the rate for the Item in column A from the Rates tab.
Use XLOOKUP (modern, cleanest): =XLOOKUP(A2, Rates!A:A, Rates!B:B, 0) If your sheet does not have XLOOKUP, INDEX/MATCH works: =INDEX(Rates!B:B, MATCH(A2, Rates!A:A, 0)) Both return 0 if not found instead of #N/A. Drag the formula down column D — relative references update for each row.
VLOOKUP, INDEX/MATCH, XLOOKUP: get the right one with Crade
Crade reads your two tables on screen and gives you the exact lookup formula that fits your specific column layout. No more cargo-culting from old Stack Overflow answers.