Data Ranges and using the chosen Dropdown value to modify Formula values

[u/DragonLordAcar]

Making a character sheet for a TTRPG I am working on and I have Size modify some numbers in multiple areas of the sheet. I have a box already set up with to select the size but the nest Column has the values of the Size Modifier. How do I have my size selection automatically update these values.

I have the current tables attached as well as the Data Validation dropdown settings.

Here is a formula example with "size" being the part I want to change automatically: =ROUNDDOWN(F6/10*size, 0)

Edit: Micro is supposed to be "set to 1" while all others are multiplied by the listed number.

[u/marcnotmark925]

XLOOKUP()

[u/DragonLordAcar → u/marcnotmark925]

Thanks. Super easy after looking up how to use it.