I am trying to create a formula that will put in a series of numbers into cells based on what the user picks on a drop-down menu.
This is a picture of the values that I want to import with the second picture being the desired final results (though it's the wrong name, that should be Platemail Armor).
Excel4.jpg - Putting information into cell Y3 by using cell Y2's value in...
Excel3.jpg - cell N2 because it is from N1
Anyone able to help on this?