Pokédex Lookup & Analytics Workbook

An interactive Excel workbook that turns a 1,000+ record Pokémon dataset into a live lookup tool, a type-effectiveness calculator, and a set of summary analytics; built entirely with native Excel functions (no macros/VBA).

Type a Pokédex ID into a single input cell and the workbook returns the Pokémon's sprite, stats, abilities, typing, and a live type-matchup breakdown against any attacking type.

Features

• Live lookup interface: Enter a Pokédex ID and instantly retrieve name, typing, base stats, abilities, sprite image, and description, powered by XLOOKUP against a structured Excel Table.
• Type-effectiveness calculator: Select an attacking type and see whether it's quadruple-weak, super effective, normal, not-very-effective, quadruple-resisted, or a complete immunity against the looked-up Pokémon's type combination, cross-referenced against a full 18x18 dual-type effectiveness matrix.
• Summary analytics (pivot tables): Breakdowns of legendary/mythical status, base stat tiers by generation, and gender distribution across the full dataset.
• Dynamic array formulas: Used for type-combo derivation and other calculated fields, avoiding hard-coded helper columns.

Repository Structure

pokelookup/
├── README.md
├── workbook/
│   └── pokelookup.xlsx              # Main interactive workbook (Look Up, Pivots, Data, Typing sheets)
├── data/
│   ├── pokemon_complete_2025.csv    # Source dataset: 1,025 Pokémon x 43 attributes
│   └── pokemon_type_chart_master.xlsx  # Reference: full dual-type effectiveness chart
└── assets/
    └── (screenshots go here)

Workbook Contents (pokelookup.xlsx)

Sheet	Purpose
Look Up	Main interface: Enter a Pokédex ID, view live stats, typing, abilities, and type-matchup results
Typing	Full dual-type effectiveness matrix used to power the matchup calculator
Pivots	Pivot table summaries: Legendary/mythical counts, stat tiers by generation, gender distribution
Data	Underlying dataset (1,025 records x 43 fields), stored as a structured Excel Table

Dataset

pokemon_complete_2025.csv contains 1,025 Pokémon records across 43 fields, including base stats, typing, abilities, physical measurements, breeding data, and several derived metrics (BMI, attack/defense ratio, offensive/defensive totals, stat tier classification).

Tools & Techniques

• XLOOKUP for all record retrieval, replacing legacy VLOOKUP/INDEX-MATCH patterns
• Structured Excel Tables for reliable, self-expanding ranges
• Dynamic array formulas for calculated fields
• IMAGE() function for in-cell sprite rendering
• Pivot tables for aggregate analysis
• Data validation for controlled dropdown input (attacking type selector)

How to Use

1. Open workbook/pokelookup.xlsx in Excel (Microsoft 365 recommended for full XLOOKUP/IMAGE support).
2. Go to the Look Up sheet.
3. Enter a Pokédex ID in the highlighted input cell.
4. Select an attacking type from the dropdown to see the live type-matchup result.
5. Check the Pivots sheet for aggregate dataset insights.

Author

Kwame Boadi Nwanwah LinkedIn · GitHub