Conditional Combo Boxes in Excel - HELP NEEDED

[lunatism]

Hi, i'm well into developing my own system (and will be hoping to post selections once completed and backtested) and i'm looking to facilate for every league that bet365 currently accomodate for (i had them email me a list). and what i'm trying to do at the moment is speed up the input process by having teams appear from combo boxes. initially i had just uk, scotland and wales, but now (as mentioned above) i want loads more. to do this i think i need some kind of conditional combo box, where first i can choose a continent, then country (in the next box), then league (in next box), then team (in final box).....soooooo the list in each box depends on what was chosen in the box before it. i tried this with if statements in excel 2007, and it works to an extent...BUT although an improvement on previous excel versions, 64 nested if's can't facilitate for the 150 odds leagues i'm trying to incorporate! Thanks!! BTW: i can provide a link that demonstrates exactly what i mean if necessary

[mcgin]

Re: Conditional Combo Boxes in Excel - HELP NEEDED Have you looked at VLOOKUP? http://msdn2.microsoft.com/en-us/library/aa140121(office.10).aspx