An order list (A:D) and three tables beside it: products and prices (J1:M9), quantity discounts (J11:K16) and region managers (J18:K22). The first five tasks fill a column for every order, rows 2 to 11. The rest answer a single question in column P, using the input next to it in column O.
Pick the function you like for each task. VLOOKUP needs the key in the first column of the table; XLOOKUP and INDEX with MATCH don't. Lock the table with $ before you fill down, and use an exact match unless the task is about bands.