Looking up a table

[Gary]

First off, I know I am a complete idiot at using Excel. That being said,
here is what I want to do.

I have been working on a dice-based roleplaying game for over four years and
I just revamped the entire system of how things work for creating new
characters. What I want to do is help speed up the process of creating a new
character by having excel do most of the work.

Here is what I do right now:
I have excel randbetween the minimum and maximum values for each of the ten
stats and then manually type them into the appropriate places.
After that I manually ad in the modifier for another part of the sheet based
on class.

What I want to do:
I want to have a table with all the stats in them that transfers over the
stats to the sheet when someone enters the race of the character and hits
calculate.
I want to have a table with all the modifiers (basically the formula is
"=(Stamina*2)+Strength+(Modifier*(Level-1))" and the modifier is between 0
and 14.) in it that puts the modifier where it needs to go depending on the
class of the character.

What I think I have to do:
If then statements that are 15 "if, then"s long that confuse the heck out of
me (one for each possible race). Then I will need to copy and past that for
each of the ten stats and adjust the row that the statement is targeting for
each cell.

All in all, I'm really confused.

 

[Bernie Deitrick]

Gary,

You rarely need to nest 15 if then's. Are your 'races' numbers? If so, you could use a CHOOSE
statement, or a MATCH with arrays if the race is less structured, but you would need to better
explain what input (races) you have, and what output you would want.

HTH,
Bernie
MS Excel MVP

 

[Gary]

The Races are not numbers. The objective is to have the following happen:

If someone types "Human" in box D1 then the following numbers are entered in
the corresponding boxes:
(all numbers are held in a table on a different worksheet. The numbers are
all randomly generated using the =Randbetween function)
B4- 10
B5- 8
B6- 13
B7- 11
B8- 8
D4- 16
D5- 14
D6- 16
D7- 9
D8- 7

The possible options for box D1 determine which list of numbers is
referenced and entered in the table. For instance, if I entered the word
"elf" into D1 it looks up a list of numbers on the table below the list for
human and displays a different set of numbers.

The second part looks up a table like this:
Vigor Nambian
Martial Artist 10 4
Weaponmaster 10 4
Archer 8 6
Rogue 8 6
Mage 4 10
Brawler 14 0
Ambient 14 0

Right now, in cell D14 and D15, the following is written:
=B5*2+B4+(F1-1)*x
=D7*2+D6+(F1-1)*y
Obviously it doesnt work and I have to look up the table for myself to ente
in the value I look up from the table. Ideally, what I want it to do is put
in 14 for x and 0 for y when someone types in "Ambient" into D2.

I hope I made this more clear. Thanks in advance for your assistance.

 

[Gary]

Can I get some sort of help please?

The Races are not numbers. The objective is to have the following happen:

If someone types "Human" in box D1 then the following numbers are entered in
the corresponding boxes:
(all numbers are held in a table on a different worksheet. The numbers are
all randomly generated using the =Randbetween function)
B4- 10
B5- 8
B6- 13
B7- 11
B8- 8
D4- 16
D5- 14
D6- 16
D7- 9
D8- 7

The possible options for box D1 determine which list of numbers is
referenced and entered in the table. For instance, if I entered the word
"elf" into D1 it looks up a list of numbers on the table below the list for
human and displays a different set of numbers.

The second part looks up a table like this:
Vigor Nambian
Martial Artist 10 4
Weaponmaster 10 4
Archer 8 6
Rogue 8 6
Mage 4 10
Brawler 14 0
Ambient 14 0

Right now, in cell D14 and D15, the following is written:
=B5*2+B4+(F1-1)*x
=D7*2+D6+(F1-1)*y
Obviously it doesnt work and I have to look up the table for myself to ente
in the value I look up from the table. Ideally, what I want it to do is put
in 14 for x and 0 for y when someone types in "Ambient" into D2.

I hope I made this more clear. Thanks in advance for your assistance.