Reference Table Manager Pro

Reference Table Manager Pro is an Excel add-in that lets you create, store, and manage reference lookup (VLOOKUP/XLOOKUP/INDEX_MATCH) tables directly inside your workbook — no external databases, no complex VLOOKUP formulas, no scattered spreadsheets. Build data validation dropdowns, publish tables to worksheets for easy editing, and keep your reference data accurate and centralised, all without leaving Excel.

What Makes Reference Table Manager Pro Unique

• No external tools required — Reference data lives inside your workbook. No databases, no cloud connections, no IT setup. Open the workbook and your tables are there.

• Portable table library — Save your most-used tables to a personal library and load them into any workbook. Build once, reuse everywhere.

• Two-way Excel Table sync — Publish reference tables as formatted Excel Tables on a worksheet. Edit data directly in the familiar spreadsheet grid, then sync changes back to storage with one click.

Who Is It For

Reference Table Manager Pro is built for anyone who manages reference data in Excel:

• Finance teams maintaining chart of accounts, cost centres, or currency code lookups

• Operations and procurement managing supplier lists, product catalogues, or pricing tables

• HR and administration standardising department codes, job titles, or office locations

• Data analysts who need consistent lookup values across multiple reports and workbooks

• Small businesses that want database-like structure without the cost or complexity of a database

Features

• Create and manage reference tables — Add, edit, and delete tables with a clean task-pane interface. Tag and search tables for quick access.

• Import from Excel ranges — Select a range in your worksheet and import it as a reference table instantly. First row becomes headers automatically.

• Data validation dropdowns — Apply dropdown lists to any cell or range from your reference table columns. Supports cascading/dependent dropdowns (e.g., pick Category → filter Products). (Pro)

• Publish to Sheet — Write reference tables as formatted Excel Tables on a worksheet for familiar spreadsheet editing.

• Sync from Sheet — Pull edits made in the Excel Table back into reference table storage with one click. (Pro)

• My Tables Library — Save tables to a personal library and load them into any workbook. Export and import libraries as JSON files for sharing. (Pro)

• Formula Builder — Build and insert lookup formulas (VLOOKUP, INDEX/MATCH, XLOOKUP) referencing your published tables without memorising syntax.