Task 1 of 2
In D2:D5, pull the price from the "Prices" sheet.
Lesson theory
Reference tables (price lists, staff lists, exchange rates) are handy to keep on a separate sheet and pull into the working table with VLOOKUP or XLOOKUP:
=VLOOKUP(B2,Prices!$A$2:$B$6,2,0)Change a price in the price list and every order recalculates.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page