Spreadsheet: 204422d1357512795-how-do-i-create-dynamic-dropdown-lists-example
Sheet: Sheet1

Pick an item ----> |  | Docent |  | Invisibly convert to 'Item Type' ->
Pick a prefix based on 'Item Type' ---> |  | Clever +5
Pick a suffix based on 'Item Type' ---> |  | Balance +1
shard [NAME] | Pref/Suff | item type |  | item types | item locations
Clever +4 | Prefix | Helmet/Hat, Goggles, Ring |  | None | ** - NONE - **
Clever +5 | Prefix | Helmet/Hat, Goggles, Ring |  | Ammo: Arrows | [NAME]
Clever +6 | Prefix | Helmet/Hat, Goggles, Ring |  | Ammo: Bolts | [NAME]
Keen | Prefix | Main Hand Weapon, Off Hand Weapon/Shield |  | Ammo: Runestone | [NAME]
Lesser Acid Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent |  | Bandana | Helmet/Hat |  | Lesser Acid Guard
Casting Dexterity | Prefix | Ring, Trinket, Gloves |  | Banded mail | Heavy Armor
Lesser [NAME] | Prefix | Docent |  | [NAME] | Main Hand Weapon |  | Lesser [NAME]
Lesser Fire Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent |  | [NAME] | Main Hand Weapon |  | Lesser Fire Guard
Lesser Ice Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent |  | Belt | Belt |  | Lesser Ice Guard
Lesser Lightning Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent |  | Boots | Boots |  | Lesser Lightning Guard
Lesser Undead Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent, Off Hand Weapon/Shield |  | Bracers | Bracers |  | Lesser Undead Guard
Life Shield | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent, Off Hand Weapon/Shield |  | Breastplate | [NAME] |  | Life Shield
Life Shield (Weapon) | Prefix | Main Hand Weapon, Off Hand Weapon/Shield |  | Brigandine | [NAME]
Lightning Guard | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent |  | Buckler | Off Hand Weapon/Shield |  | Lightning Guard
Lionheart | Prefix | Heavy Armor, [NAME], Light Armor, Clothing, Docent, Off Hand Weapon/Shield |  | Chain shirt | Light Armor |  | Lionheart
Maladroit | Prefix | Main Hand Weapon, Off Hand Weapon/Shield |  | Chainmail | [NAME]
Metalline | Prefix | Main Hand Weapon, Off Hand Weapon/Shield |  | Circlet | Helmet/Hat
Minor Spell Penetration I | Prefix | Ring, Trinket, Main Hand Weapon, Off Hand Weapon/Shield |  | Cloak | Cloak
Minor Spell Penetration II | Prefix | Ring, Trinket, Main Hand Weapon, Off Hand Weapon/Shield |  | Club | Main Hand Weapon
Aberration Bane | Suffix | Main Hand Weapon, Off Hand Weapon/Shield |  | Composite [NAME] | Main Hand Weapon
Acid Lore | Suffix | Trinket, Main Hand Weapon, Off Hand Weapon/Shield |  | Composite [NAME] | Main Hand Weapon
Acid Resistance | Suffix | Heavy Armor, [NAME], Light Armor, Clothing, Docent, [NAME], Ring, Off Hand Weapon/Shield |  | Crown | Helmet/Hat |  | Acid Resistance
Alignment | Suffix | Main Hand Weapon, Off Hand Weapon/Shield |  | Dagger | Main Hand Weapon
Animal Bane | Suffix | Main Hand Weapon, Off Hand Weapon/Shield |  | Docent | Docent
[NAME] [+1] | Suffix | Goggles, Trinket |  | [NAME] | Main Hand Weapon
[NAME] [+2] | Suffix | Goggles, Trinket |  | Falchion | Main Hand Weapon
Accuracy [+4] | Suffix | Goggles, Trinket |  | Full plate | Heavy Armor
Axeblock | Suffix | Heavy Armor, [NAME], Light Armor, Clothing, Docent, Off Hand Weapon/Shield |  | Gloves | Gloves |  | Axeblock
Balance +1 | Suffix | Helmet/Hat, Goggles, Cloak, Ring, Bracers, Trinket, Necklace, Gloves, Belt, Boots |  | Goggles | Goggles
Balance +10 | Suffix | Helmet/Hat, Goggles, Cloak, Ring, Bracers, Trinket, Necklace, Gloves, Belt, Boots |  | Great Axe | Main Hand Weapon
Balance +11 | Suffix | Helmet/Hat, Goggles, Cloak, Ring, Bracers, Trinket, Necklace, Gloves, Belt, Boots |  | Great Club | Main Hand Weapon
 |  |  |  | Great Crossbow | Main Hand Weapon
 |  |  |  | Great Sword | Main Hand Weapon
 |  |  |  | Half plate | Heavy Armor
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | Handwraps | Main Hand Weapon
 |  |  |  | Hat | Helmet/Hat
 |  |  |  | Heavy Crossbow | Main Hand Weapon
 |  |  |  | Heavy Mace | Main Hand Weapon
 |  |  |  | Heavy Pick | Main Hand Weapon
 |  |  |  | Heavy shield | Off Hand Weapon/Shield
 |  |  |  | Helmet | Helmet/Hat
 |  |  |  | Hide armor | [NAME]
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | Kukri | Main Hand Weapon
 |  |  |  | Leather | Light Armor
 |  |  |  | Light [NAME] | Main Hand Weapon
 |  |  |  | Light Hammer | Main Hand Weapon
 |  |  |  | Light Mace | Main Hand Weapon
 |  |  |  | Light Pick | Main Hand Weapon
 |  |  |  | Light shield | Off Hand Weapon/Shield
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | Longsword | Main Hand Weapon
 |  |  |  | Mask | Helmet/Hat
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | Necklace | Necklace
 |  |  |  | Padded | Light Armor
 |  |  |  | Quarterstaff | Main Hand Weapon
 |  |  |  | Rapier | Main Hand Weapon
 |  |  |  | Repeating Heavy Crossbow | Main Hand Weapon
 |  |  |  | Repeating Light Crossbow | Main Hand Weapon
 |  |  |  | Returning Throwing Axe | Main Hand Weapon
 |  |  |  | Returning Throwing Dagger | Main Hand Weapon
 |  |  |  | [NAME] | Main Hand Weapon
 |  |  |  | Ring | Ring
 |  |  |  | Rune Arm | Trinket
 |  |  |  | Scale mail | [NAME]
 |  |  |  | Scimitar | Main Hand Weapon
 |  |  |  | Short Sword | Main Hand Weapon
 |  |  |  | Shortbow | Main Hand Weapon
 |  |  |  | Sickle | Main Hand Weapon
 |  |  |  | Splint mail | Heavy Armor
 |  |  |  | Studded leather | Light Armor
 |  |  |  | Tiara | Helmet/Hat
 |  |  |  | Tower shield | Off Hand Weapon/Shield
 |  |  |  | Trinket | Trinket
 |  |  |  | War Hammer | Main Hand Weapon