V
Virtanis
I hope you veterans out there aren't bothered by my question, but I'm
completely stumped.
Background: I'm designing an excel workbook that will help me and my
friends keep notes and track stuff for a boardgame I've developed. The
most important aspect of this workbook is the "battle page" - the
display and comparison of two army groups: attacker and the defender.
Each player (game can have up to 6 players) has up to 12 army groups at
his command. Each army group can hold any number of units of 18
specific types (Parthian cavalry, Balaeric slingers, Roman Legionaires,
etc...)
What I'm trying to do is build a sheet that will display the entire
contents of *one* attacking army on the left (infantry, cavalry, etc..)
and *one* defending army on the right.
I'm able enough to use drop down lists to select the attacking player
and defending player (two dropdown lists of 1-6). I'm also okay with
using a dropdown list for both player's armies (two lists of 1-12).
What I'm really stuck on is how to pull the data from the army sheet to
these display fields based on the two conditions above. If/Then was my
first guess, but there are far too many configurations to cover with
If/Then since nesting is limited.
Lookup seems like it might work, but every attempt at getting this to
work has failed me.
I'm sorry if this seems elementary for some. Any suggestions would be
welcome.
completely stumped.
Background: I'm designing an excel workbook that will help me and my
friends keep notes and track stuff for a boardgame I've developed. The
most important aspect of this workbook is the "battle page" - the
display and comparison of two army groups: attacker and the defender.
Each player (game can have up to 6 players) has up to 12 army groups at
his command. Each army group can hold any number of units of 18
specific types (Parthian cavalry, Balaeric slingers, Roman Legionaires,
etc...)
What I'm trying to do is build a sheet that will display the entire
contents of *one* attacking army on the left (infantry, cavalry, etc..)
and *one* defending army on the right.
I'm able enough to use drop down lists to select the attacking player
and defending player (two dropdown lists of 1-6). I'm also okay with
using a dropdown list for both player's armies (two lists of 1-12).
What I'm really stuck on is how to pull the data from the army sheet to
these display fields based on the two conditions above. If/Then was my
first guess, but there are far too many configurations to cover with
If/Then since nesting is limited.
Lookup seems like it might work, but every attempt at getting this to
work has failed me.
I'm sorry if this seems elementary for some. Any suggestions would be
welcome.
