Looking up data in a different worksheet based on criteria

Gosh! It's been that many years (2010) since I first came here looking for help and found a great place to learn. Time flies.

The help and guidance provided by this forum has lasted me this many years. Times have changed and I am looking for help & suggestions on how to modify my original costing spreadsheet to reflect my current needs.

As well as doing phone sales/orders, I am finding myself bidding on more and more bid tenders for my products. While I have find tuned the look up solution provided by ConneXionLost, to auto round up the next highest Customs value, I have a few other ideas I would like to implement on this sheet to better serve my needs.

Basically,

1) The "Our Costs" tab - Is it possible to have the sheet ask me whether I want Brokerage pricing on individual or multiple items and automatically insert the correct formula in the cell. Some of my bid tenders are awarded individually and some are awarded on a whole.

2) The "Mark Up" tab - Is it possible to again have a pre-defined drop down box with pre-filled in percentages instead of scrolling across the entire page(s)?

I have deleted a few of the non-necessary tabs (part numbers, trailer space, local/national taxes) in this worksheet.

Any help or guidance in how/if this is possible is much appreciated.