IF Statements and data validation

[Belzace]

Is it possible to use the if function to select data from a list based on input in other columns?
For example if 1A = 3.1415 then B1(or A2) would Pull values from a list for whatever A1 equals.
If not is there another way to achieve this? I'm rather new to excel and I'm building a Computer part choser. So if I select a processor I want the drop down box for motherboards to only show motherboards that match that processor's socket type. I've attached a copy if it helps to view how I have things set up. ( I'm building it on my tablet so none of the data validation is placed yet. Sheet 2 is the lists)

[Belzace]

Edit: I'd like to have a row of computer components, and if I select "RAM" from the drop down list, then the adjacent box would be a drop down list of different ram i have created a list for. As apposed to a longer list of all the different parts I would normally have to choose from.

[windy58]

Create named ranges for your components. (I would make them dynamic, this way you can add to the list and they will adjust)
Then in data validation for cell B2 enter the following:
In the allow box select List
In the Source box place =INDIRECT($A$3)
In column C/D use a vlookup:
=VLOOKUP(B3,Sheet2!$C$1:$F$33,4,0)
Adjust the 4 to suit
See attached
Windy

[Belzace]

Thanks, that helps a lot actually. Also, I could not open the doc you attached, from my tablet. I'll just wait till I get my laptop. Just bought a sager NP8152-2 :D