Spreadsheet: 112839d1308830930-simple-lookup-but-strange-results-what-am-i-missing-desolation_chargen1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Archetype
 |  |  |  |  |  |  |  | Player |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Motivation
 |  |  |  |  |  |  |  | Race |  |  |  | Gnome |  |  |  |  |  |  |  |  |  |  | Personality
 |  |  |  |  |  |  |  | Nationality |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Human
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style point uses: (those below + GM fiat) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Elf
Primary Attributes |  |  |  |  |  |  |  |  |  |  |  |  | Starting Characters: |  |  |  |  |  |  |  |  |  | Bonus Dice: 1 point per die- Lasts one roll |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Dwarf
Body |  |  |  |  |  | Charisma |  |  |  |  |  |  | 15 primary attribute points |  |  |  |  |  |  |  |  |  | Boost Talent: 2 points per level- Lasts one Combat/scene |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Rover
Dexterity |  |  |  |  |  | Intelligence |  |  |  |  |  |  | 15 skill points |  |  |  |  |  |  |  |  |  | Damage Reduction: 2 points per damage point |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Goblin
Strength |  |  |  |  |  | Willpower |  |  |  |  |  |  | 1 Talent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Orc
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 Experience points |  |  |  |  |  |  |  |  |  | Health |  |  |  |  |  |  |  |  |  | Current |  |  |  |  |  | -1 | Loranthian
Secondary Attributes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Status |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | Gnome
Size |  |  | 0 |  |  | Initiative |  |  |  |  |  | Active Defense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Mongrel
Move |  |  |  |  |  | Defense |  |  |  |  |  | Passive Defense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Mongrel (Large)
Perception |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lethal |  |  |  |  | Nonlethal |  |  |  |  | Burn |  |  |  |  |  | -1 | Mongrel (Small)
Skills
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Why doesn't this lookup() work?
 |  |  |  |  | Attrib. |  |  | Base |  |  | Level |  |  | Rating |  | ([NAME].) |  |  |  |  |  |  |  |  | Attrib. |  |  | Base |  |  | Level |  |  | Rating |  | ([NAME].)
Academics |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Larceny |  |  |  |  |  | Dex |  | -- |  |  | + |  |  | =
® | History |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Linguistics |  |  |  |  |  | Int |  | -- |  |  | + |  |  | =
® | Law |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Magic
® | Literature |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Animism |  |  |  |  | Chr |  | -- |  |  | + |  |  | =
® | Philosophy |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Beguiling |  |  |  |  | Chr |  | -- |  |  | + |  |  | =
® | Religion |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Blood Runes |  |  |  |  | Int |  | -- |  |  | + |  |  | =
Acrobatics |  |  |  |  | Dex |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Elemental |  |  |  |  | Chr |  | -- |  |  | + |  |  | =
[NAME] |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Necromancy |  |  |  |  | Int |  | -- |  |  | + |  |  | =
Archery |  |  |  |  | Dex |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Primal |  |  |  |  | Int |  | -- |  |  | + |  |  | =
Art |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ® | Rune |  |  |  |  | Int |  | -- |  |  | + |  |  | =
® | Music |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Sorcery |  |  |  |  | Int |  | -- |  |  | + |  |  | =
® | Painting |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Shadow |  |  |  |  | Int |  | -- |  |  | + |  |  | =
® | Sculpture |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Medicine |  |  |  |  |  | Int |  | -- |  |  | + |  |  | =
® | Writing |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | [NAME] |  |  |  |  |  | Str |  | -- |  |  | + |  |  | =
Athletics |  |  |  |  | Str |  | -- |  |  | + |  |  | = |  |  |  |  |  | Performance
Brawl |  |  |  |  | Str |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Acting |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Attributes
Brew Magic Potion |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Dancing |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Body
Con |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Musical Instrument |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Chr
Craft |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ® | Oratory |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Dex
® | Apothecary |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | ® | Singing |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Int
® | Bowyer/Fletcher |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Ride |  |  |  |  |  | Dex |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Str
® | Carpentry |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Sailing |  |  |  |  |  | Dex |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Will
® | Smithing |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Scavenge |  |  |  |  |  | Int |  |  |  |  | + |  |  | =
Craft Magic Item |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Stealth |  |  |  |  |  | Dex |  | -- |  |  | + |  |  | =
Diplomacy |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  | Survival |  |  |  |  |  | Int |  | -- |  |  | + |  |  | =
Empathy |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | Warfare |  |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Penalties
Gambling |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | * Specialty Attack 1 |  |  |  |  |  |  |  | -- |  |  | + |  |  | =
Intimidation |  |  |  |  | Chr |  | -- |  |  | + |  |  | = |  |  |  |  |  | * Specialty Attack 2 |  |  |  |  |  |  |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Skills
Investigation |  |  |  |  | Int |  | -- |  |  | + |  |  | = |  |  |  |  |  | * Specialty Attack 3 |  |  |  |  |  |  |  | -- |  |  | + |  |  | = |  |  |  |  |  |  | Archery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brawl
Equipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | None
Weapon |  |  |  |  |  |  | Cond |  |  | Skill Used |  |  | Damage |  |  | Size |  | Attack |  |  | (avg) |  |  | Weight |  |  | Rare |  | Status |  |  |  | [NAME] |  |  |  |  |  |  | Spec 1 |  |  | Attack Value Display Conditions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spec 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spec 3
Armor |  |  |  |  |  |  | Cond |  |  | Def |  | Str |  | Dex |  | Weight |  |  | Rare |  | Status |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Str Penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attributes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Body
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dex
Notes on Weapons and Armor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miscellaneous Attribute Penalties |  |  |  |  |  |  |  |  |  |  |  |  |  | Int
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Body |  |  |  |  |  |  |  |  |  |  |  |  |  | Str
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dexterity |  |  |  |  |  |  |  |  |  |  |  |  |  | Will
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Strength
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Charisma
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intelligence |  |  |  |  |  |  |  |  |  |  |  |  |  | L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Willpower |  |  |  |  |  |  |  |  |  |  |  |  |  | N
Gear |  |  |  |  |  |  | Cond |  |  | # |  | Weight |  |  | Total Weight |  |  |  | Rare |  |  | Talents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good |  |  | Talent Checks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Worn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | Improv
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary Skills |  |  |  |  | Level |  |  | Secondary Skills |  |  |  |  | Level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Robust
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Swift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Please type these [NAME] in exactly as they appear
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Talents that change skills |  |  |  |  |  |  |  | Know-it-all
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Switch attribute skill |  |  |  |  |  |  |  | Talents that [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Bold Defense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculated Attack |  |  |  |  |  |  |  | Calculated Defense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Focussed Attack |  |  |  |  |  |  |  | Focussed Defense
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flaws
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 10 | 25 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 25 | 50 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 50 | 100 | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 100 | 250 | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 250 | 500 | 750
Total Weight: |  |  |  |  |  |  |  |  |  |  |  |  | Dexterity Penalty
Encumberance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ascondean
Light |  |  |  |  |  |  |  |  |  | Languages |  |  |  |  |  |  |  |  |  |  |  | Experience costs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cushu
Medium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Primary Attribute: New Attribute Level x 5 Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dwarvish
Heavy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill: New Skill Level x 2 Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Elvish
 |  | Currently |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: 3 points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gnomish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Talent: 15 Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Ascondean
Background |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Experience Points |  |  |  |  |  |  |  |  |  | Spent: |  |  |  |  |  |  |  | Kar'Darnish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | History of Experience Spending |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lanarian
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loranthian
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Loslolin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oruskan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rover
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saikin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warland Pidgin