# Fictional order lookup — independent answer check

This is the expected result for the unchanged `xlookup-order-practice.xlsx` input. It was calculated directly from the five catalog entries and six order rows, independently of Excel's formula engine.

| Order ID | SKU | Quantity | Expected unit price | Expected line total | Source check |
| --- | --- | ---: | ---: | ---: | --- |
| SO-1001 | BK-101 | 2 | $24.00 | $48.00 | Price found in the catalog |
| SO-1002 | MUG-415 | 1 | $18.00 | $18.00 | Price found in the catalog |
| SO-1003 | PN-330 | 4 | $12.50 | $50.00 | Price found in the catalog |
| SO-1004 | NO-999 | 1 | Missing SKU | Review SKU | Key is absent from the catalog |
| SO-1005 | BAG-520 | 3 | $27.50 | $82.50 | Price found in the catalog |
| SO-1006 | KIT-210 | 2 | $39.00 | $78.00 | Price found in the catalog |

**Five numeric line totals:** $48.00 + $18.00 + $50.00 + $82.50 + $78.00 = **$276.50**. The missing row has no price and must not be counted as $0 or assigned an invented value.

## Check before relying on the result

- Catalog keys in `A2:A6` are unique and nonblank in the supplied file.
- `NO-999` does not occur in the supplied catalog.
- Copying the formula preserves `$A$2:$A$6` and `$C$2:$C$6` as fixed catalog ranges.
- A new catalog row below row 6 is outside these fixed practice ranges; extend both ranges together if you add products.

The workbook contains fictional products and orders. This answer check was calculated independently of Excel. A separate English Excel for the web test confirmed the D2:D7 lookup results and the $276.50 total with one Review SKU; see `ui_captures/manifest.json` for the captured app steps.