Spreadsheet: 220083d1363049486-function-like-vlookup-that-can-be-used-to-lookup-sequential-values-based-on-same-criteria-example-9-
Sheet: Sheet1

[NAME] | Lvl | Duration | M/F | Wizard | Potion | Known | Preped | Description
Adjuring Step | 1 | 1 round/lvl |  | YES | NO |  |  | You can move slowly and safely and still cast spells, until you move quickly, make an attack, or cast a harmful spell.
[NAME] | 1 | 2 Hours/lvl |  | YES | YES | X |  | Triples carrying capacity of a creature.
Anticipate Peril | 1 | 1 min./lvl |  | YES | YES |  |  | Target gains a bonus on one initiative check.
Bomber's Eye | 1 | 1 round/lvl |  | NO | NO | X |  | Increases thrown weapon range; +1 attack.
Comprehend Languages | 1 | 10 min./lvl |  | YES | NO |  |  | You understand all spoken and written languages.
Crafter's Fortune | 1 | 1 day/lvl |  | YES | YES |  |  | Subject gains +5 on next Craft check.
Cure Light Wounds | 1 | Instantaneous |  | NO | YES | X |  | [NAME] 1d8 damage + 1/level ([NAME]).
Detect Secret Doors | 1 | 1 min./lvl |  | YES | NO |  |  | Reveals hidden doors within 60 ft.
Detect Undead | 1 | 1 min./lvl |  | YES | NO |  |  | Reveals undead within 60 ft.
Disguise Self | 1 | 10 min./lvl |  | YES | NO |  |  | Changes your appearance.
Endure Elements | 1 | 24 hours |  | YES | YES | X |  | Exist comfortably in hot or cold regions.
[NAME] | 1 | 1 min./lvl |  | YES | YES | X |  | Humanoid creature doubles in size.
Expeditious Retreat | 1 | 1 min./lvl |  | YES | NO | X |  | Your base speed increases by 30 ft.
Illusion of Calm | 1 | 1 min./lvl |  | NO | NO | X |  | You appear to be standing still, even when you take some actions.
Identify | 1 | 3 rounds/lvl |  | YES | NO | X |  | Gives +10 bonus to identify magic items.
Jump | 1 | 1 min./lvl |  | YES | YES |  |  | Subject gets bonus on Acrobatics checks.
[NAME] | 1 | 1 min./lvl |  | NO | YES | X |  | Gain +2 Perception and low-light vision.
Longshot | 1 | 1 min./lvl |  | YES | NO | X |  | Grants a +10-foot bonus to the range increment for any ranged weapon fired.
Negate Aroma | 1 | 1 hour/lvl |  | NO | YES | X |  | Subject cannot be tracked by scent.
Polypurpose Panacea | 1 | Varies |  | YES | NO |  |  | Gain a relaxing or entertaining effect.
[NAME] | 1 | 1 min./lvl |  | YES | YES | X |  | Humanoid creature halves in size.
See Alignment | 1 | 1 round/lvl |  | YES | NO |  |  | Pick an alignment; in your sight, creatures and items with that alignment emit a ghostly radiance.
Shield | 1 | 1 min./lvl |  | YES | NO | X |  | Invisible disc gives +4 to AC, blocks magic missiles.
Shock [NAME] | 1 | 1 min./lvl |  | YES | NO |  |  | A shield of force protects you until you dismiss it in an explosion of electricity.
Stone Fist | 1 | 1 min./lvl |  | YES | NO |  |  | Your unarmed strikes are lethal.
Targeted Bomb Admixture | 1 | 1 round/lvl |  | NO | NO | X |  | Empowers bombs you throw to deal more damage to a single creature.
Touch of the Sea | 1 | 1 min./lvl |  | YES | YES | X |  | Swim speed becomes 30 ft.
True Strike | 1 | 1 round |  | YES | NO |  |  | +20 on your next attack roll.
Vocal Alteration | 1 | 1 min./lvl |  | YES | YES |  |  | Disguise target's voice.
[NAME] | 1 | 1 hour/lvl |  | YES | YES |  |  | Target appears younger.