linking text to values

Hey everyone,

I have a problem that I can't seem to wrap my head around at the moment. I am trying to create somewhat of a conversion matrix for the rogue class in World of Warcraft. The user can input a value, and then select what this value should represent and convert it into another value.

The way in which I am trying to accomplish this is make two drop down boxes, the first one displaying what the data actually is (ie Agility), the second one into what it should be converted (Attack Power). So the user can then put in the number 5, select 'Agility' from the first drop down box and 'Attack Power' from the second, and a number will come out which represents how much attack power 5 agility represents. The problem I am having is that I have no idea how to link this conversion.

I can make lists/drop down boxes, but no idea how to attach values to the text in the boxes. How do I get the sheet to figure out that x attack power is x agility (values are already calced in other part) and that I right now want to make agil into ap.

Any input would be greatly appreciated (since I suck at excel stuff).

Hello Arjan,

Not being a Warcraft player, it would help if you could tell me where on the the worksheet to find your data for the Drop Downs. I see where you want to locate it, but I need data to put into the Drop Downs. Thanks.

Sincerely,
Leith Ross