Excel 2007 : LOOKUP Formula (I think)

Hey guys, I'm not too great at stringing formulas together and getting a working result, so I need some help.

I'm building this for me and a few of my friends in a gaming community. Basically I have tabs for each skill and I've also got a tab listing out typical methods of doing the skill, thus allowing us to work out the information we want with Excel.

\1
Incomplete method list ^^

I want to be able to type the method number on the skilling tab which will inable the information to change on that tab from the previous method to the new one.

\1
That's a typical skilling tab.

I was thinking about a LOOKUP formal but I'm not sure how it would work. There would be 5 methods per skill at the most.

I hope you can understand what I'm trying to achieve, if not I don't mind explaining it a little differently.

Thanks,
~Nashy

Hey, thanks for finding me again.

I remember combo boxes so I'm going to see if they'll work for me, I'll have the results in a little while.