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.


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.


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

G'day Nashy,

For starters here is some information on the Lookup Function.

http://www.techonthenet.com/excel/formulas/lookup.php

If this doesn't help explain differently

Cheers

__________________
If you receive a solution....Please let us know:
1) Click the EDIT button on your first post
2) Click the GO ADVANCED button
3) Select SOLVED from the Title dropdown (under the Reason for Editing box)
4) Click the SAVE CHANGES button
Note: If it's more than 2 days after your first post, please ask a moderator to mark the thread SOLVED for you.

Office 2007
Any Feedback Welcomed

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.