---

doc_type: example title: Manual Price Overrides summary: End-to-end Runline U example: combine live prices with visible manual override values. product: u tags: - overrides - tables - lookup use_case: Combine live market data with manual overrides in an auditable workbook audience: intermediate

---

Manual Price Overrides

A workbook keeps manual price overrides in a dedicated table, combines them with live data, and uses lookup formulas to calculate the effective price used by reports.

Files Used in This Example

• Usage Examples source workbook
• Advanced Usage Recipes source workbook

Related Guides

• Manage Manual Overrides
• Grids, Tables, and Array Shaping
• U.VAPPEND

---

Step 1: Keep Manual Inputs Visible

Put manual prices in a dedicated table or clearly labeled range.

---

Step 2: Combine Manual and Live Values

Stack the preferred source before the fallback source.

=U.VAPPEND(manual_data,live_data)

---

Step 3: Lookup the Effective Value

Use a lookup against the combined table.

=U.VLOOKUP(symbol,U.VAPPEND(manual_data,live_data))

---

Step 4: Add Navigation or Sync

Help users move from a displayed value to its override input, or keep two edit locations aligned.

=U.SET_CLICKVALS(symbol_cell,display_range,U.RANGE_REF(override_cell))

=U.SYNC_CELLS(local_input,central_override_input)

What’s happening here?

The override is not hidden inside the lookup formula. Users can inspect the manual table, the live table, and the combined effective value.