FORMULA SOLUTION

Hello AHMETDEMIR 

It is a little difficult to understand how you are using the list of items.

You mentioned drop downs, and you mentioned being able to dynamically see the prices when you choose a product. Without seeing a demonstration or several screenshots, or even a mock-up of what you are trying to accomplish I am only able to make assumptions and solutions based on my assumptions.

If you want to be able to choose a product, then compare products and pricing, a pivot table might help. You could use filters to choose your unique code that would have the 5 different company prices  (maybe even a combination of 2 or more filters if you want to add to your quote list to refine the list by grouping/categorizing your products).

If you want to create something like a custom form, you could use a combination of data validation and vlookup on a different worksheet. However, it may not be viable depending on your list and whether you want one drop down with every unique product, or if you want to create groups of different drops down values (perhaps organized/categorized together) to have more manageable sized drop down lists).

Data validation will work like a drop down, then the cell next to it could use that value to do a vlookup to get the price. This would provide a dynamic price that changes when you choose a different value in the drop down.