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?