Bjarkmundur
2019-09-25, 03:06 PM
I thought about consolidating all my random tables into a spreadsheet.
Random Table
Column
Dice
Dice Result
Crit Table
Melee Weapon
1d100
56
This is a dropdown^
This is a dropdown^
This is fetched information
based on the two drop-
down menus chosen
This what we type in based on the physical dice roll
Then there's another cell with the effect.
We love random tables, and this would significantly reduce the time spent flipping through papers and finding the right table. The problem is that I don't know how to 'fetch' information based on conditions.
With this sheet we can simply roll the dice, and have the result appear in just a couple of clicks.
Can anyone help me code this?
EDIT: I started with my limited knowledge over here (https://docs.google.com/spreadsheets/d/1NfxAz5ipRDEIQwfs1JWnRwxZ6-vRVa9SveIrcwBPu7U/edit?usp=sharing).
VLOOKUP seems to be helping, but it can only use one input. Anyone?
Random Table
Column
Dice
Dice Result
Crit Table
Melee Weapon
1d100
56
This is a dropdown^
This is a dropdown^
This is fetched information
based on the two drop-
down menus chosen
This what we type in based on the physical dice roll
Then there's another cell with the effect.
We love random tables, and this would significantly reduce the time spent flipping through papers and finding the right table. The problem is that I don't know how to 'fetch' information based on conditions.
With this sheet we can simply roll the dice, and have the result appear in just a couple of clicks.
Can anyone help me code this?
EDIT: I started with my limited knowledge over here (https://docs.google.com/spreadsheets/d/1NfxAz5ipRDEIQwfs1JWnRwxZ6-vRVa9SveIrcwBPu7U/edit?usp=sharing).
VLOOKUP seems to be helping, but it can only use one input. Anyone?