I am trying to make player batting cards for a game that uses a three dice, 10-39 numbering sytem with 216 possible results. I have two tables-one representing my source table-(chances each dice number will be rolled out of 216 chances) a second table that represents set of numbers and result of a players individual batting card. My question is how can I get excel to populate the card result row on my source table based on the data (on card chances/216) from the players card totals. For example HB has one chance and matching it to 19 on the source table is pretty simple. It becomes more complex when an F=27 and more than one value from the source table is needed. Also working out the many number options. Thanks for any help in advance and I do have a worksheet if this would help.
I have a Source Table as seen below:
I also have a set of numbers that the players card is based upon as seen below:
|RESULT ON PLAYER’S CARD||HB||2A||BB||1D||3||E||2M||1||1+||1M||2||HR||SO||FM||SF||1A||GA||DP||MS||G||F|
|ON CARD CHANCES/216||1||2||3||4||4||4||5||7||8||8||8||8||9||10||15||16||18||18||19||22||27|