Google Docs Help

[Devon_Pearce]

Hey guys so I use a google doc I downloaded to create my characters for Pathfinder, and while there are some parts that are programmed to auto populate sections, one part is not, and thats the EXP to next level. They have a lookup table set up for what the different experience requirements are for each level and even for if your doing slow medium or fast leveling so thats awesome, but it makes it a little hard to lookup a value as where it needs to look for the value is based on 2 separate values. First depending on the values of one drop down menu on the same page, it needs to pick one of three columns on another page, and then based on the number value in another page it needs to find the row, and then based on the column and the row from those two parts it needs to lookup and display a value from the table on another page. SO basically i need to program something like this.

If the value of AT17 is slow then output Q, if medium then R, if fast then S

Sum the values of V5, AJ5, and AV5 on Stats, Skills, Weapons and output the value, this value must then have the value 2 added to it and that total output. 

Then it needs to look up the value on the table on page Mods Bonuses and Skills based on the values output by those two equations

 

Any help is appreciated.