Link Multiple Data to Multiple Drop Down List

I hope I am describing this correctly. I am self taught Excel user for the past 10 years and am pretty good, but I am creating a report for work and I cannot get a function to work (or know if it is even possible). I need to link pricing data to product data from a pick/drop down list.

For example, I have a pick/drop down list of products Widget, Wipple, Werly, & Weeky. Each has a respective cost of $5, $15, $25, and $35. If I pick Widget or Wipple from the drop down list and link it to a quantity in a different cell, I want it to automatically calculate the total amount based on the predeterminted cost and quantity. I got it to work for just one item perfectly (2 Widgets @ $5 Each = $10), but how do I get it to work with the rest of the list items and have the respective costs linked to them.

This is what I used for the one that works: =IF(G2="Widge","5")*H2

G2 = 1 of 4 possible drop down options from a list
5 = Cost
H2 = Qty

Like I said, this works perfect, but how do I extend this to the rest of the pick list items Wipple, Werly, & Weeky? It seems using the IF/THEN scenerio you can only do it once. Is this true? Can I do multiple IF/THEN functions in one cell? Am I using the wrong function?

Please help, I have been pulling my hair out trying to figure out.

Hi

I have attached an example of what I think you need. please let me know if you need something different.

Regards

Jeff