Formula required to arrive at price

You are missing some vital information, like the cost price of 1 item - maybe that is shown in one of the columns not shown in your table, but no one can give you the formula you need to find the 'price' unless there is some information showing dollars somewhere else on the spreadsheet. So the formula will include the price of 1 item x Col F and Col G

The price in 'I5' is determined by the results in 'F5' and 'G5' which are both text entries. The unit price is determined by this combination, it's not related to any other cells in the sheet.

I'm using this sheet to calculate cost of various building materials, and this section is for sheet metal. 'F5' is one of two different coatings on the base metal, and 'G5' is one of four different profiles the sheet metal. So there are eight different price outcomes, which is what I would like this formula to input for me automatically. Obviously I would have to input the eight different outcomes into the formula. I looked around on google before posting here, but I couldn't find anything that seemed relevant.

Let me know if this works for you...
I used the Data Validatiom - USED the LIST fucntion to reference the other sheets.
I used a vlookup for to show the results, once the drop down is selected .. the calculation is basic math
Have a look at the attached and let me know ...

Unfortunately I can't use basic math in this situation, as there is no set base price for each item in the different categories. The price for the combination is determined by the supplier. I will have to put each end result into the formula.

Basically what I need is:

if 'I5'=A and 'G5'=W, 'I5'=$8.98 (or whatever the price is for that combination).

I'm sorry if I'm not explaining this very well, I've never tried to use a formula making a calculation based off text limited text entries. The spreadsheet as a whole is used for quoting supply and install of building products, but previously required a lot of manual input. I am trying to simplify it, so that inexperienced estimators can produce accurate quotes without extensive product knowledge.

Did you take a look at the spreadsheet i uploaded

My solution has the drop down picklist for coatings and then a drop down selection for the four different types of sheet metal.. the FINAL PRICE is determined by anyone of the multitude of combinatios.
Take a look at the uploaded sheet and and select from the DROP DOWNS (highlighted in red) ... and see the resulting outputs ... then let me know.

I did have a look at your formula, the problem is that I can't set a price for each drop down selection unfortunately, only a price for the end result. There is no set price for the individual coating, and no set price for the individual profiles, so I can't just add the two together.

Okay .. so not to sure how you arrive at a Final Price if none of the components have prices .. SO I AM GOING BACK TO BASICS to understand ... does the attached represent the problem from the intial post
Metal Coatings Basics.png

They are not so much components, just attributes of one single component. The attached sheet does represent my problem basically.

It would be nice if each attribute had a base price to work with, but if that was the case I wouldn't be here >.<

OK Deekappa as people have tried to understand your situation but to no avail, I suggest YOU upload a sample of what you expect and then others work on the how - right now people are trying to create what we think you want without knowing what it is you really want

I agree Ursul ... it is a tad confusing what is exactly needed. He wants to arrive at a final price, based on two variables .. which have no price ... so the result is a x or y