Simple dependant dropdown list

Hi, I'm making a list of pc parts, and I wanted to be able to change let's say the graphics card and have it's price changing with it on the column next to it, so it would change the total as well.

using the IF function I was able to change between two prices, but I want to have more than 2 options, and more than just a dropdown list for the gpu.

here's my file attached:

Hi there,

I believe VLOOKUP is what you're after. It looks up a particular cell, and then tries to find it from a table, and returns the value in one of the columns next to it, depending on how you structure your formula. I've implemented it for you as it took seconds to do.

Let me know if this helps.