Hi
Some days ago I create table where I select building, and after that floor, and in some cells show up names of people who lives there.
That work great.
I tried do something like that for Travian (web game)
I create 3 drop menus
In first tribes, in second troops and third barrack level
After I choose in drop menu 1 for example Romans, in drop menu 2 via formula indirect (Mr. Excel help me on that on youtube) shows Romans troops. Good.
But, problem is when I tried to select barrack level, for some troops I can select, for other not.
Same problem with Gallics and Teutonics.
Point of drop menu 3 is time, when I choose for example Romans, Legionnaire and level 4, and in table write 50 unit, I see time which is need for making that 50 troops.
So, why drop menu 3 doesn't work properly?
Some days ago I create table where I select building, and after that floor, and in some cells show up names of people who lives there.
That work great.
I tried do something like that for Travian (web game)
I create 3 drop menus
In first tribes, in second troops and third barrack level
After I choose in drop menu 1 for example Romans, in drop menu 2 via formula indirect (Mr. Excel help me on that on youtube) shows Romans troops. Good.
But, problem is when I tried to select barrack level, for some troops I can select, for other not.
Same problem with Gallics and Teutonics.
Point of drop menu 3 is time, when I choose for example Romans, Legionnaire and level 4, and in table write 50 unit, I see time which is need for making that 50 troops.
So, why drop menu 3 doesn't work properly?
