Click in cell B3, note that you can choose a product from the drop down list. This allows the company to select which product they wish to perform a CVP for. Ensure that calculations will return the correct answers regardless of which product is selected.

In B4 use a formula to retrieve the Unit Sales Price from the Fixed Costs sheet for the product shown in B3.

what is the formula to retrieve the price from two different spreadsheets(i mean in one file) in excel assignment?