- In short
- Lookup from Table matches a key column and brings values from a second table into the columns to the right of your main table. The default output is static values; you can also have it written as the fill-down-safe XLMIND_LOOKUP formula. Besides exact matching, fuzzy matching is available at High, Medium or Low strictness. The source table stays unchanged and everything runs on your computer.
What it is for
Lookup from Table is used to bring matched values from a lookup table into the main table (XLOOKUP-style).
When to use it
Used when adding customer details to an order list, pulling descriptions from a code list, or matching two tables on a key column.
Example scenarios
- Bring customer/product details into an orders table by key.
Modes
- Static values (default)
- Write as a formula (XLMIND_LOOKUP)
- Exact match
- Fuzzy match (High / Medium / Low)
What it needs
Pick main table + lookup table and an options dialog (key pairs, return cols, fuzzy, write-formulas); no-room-right refused; protected refused. Supported data types: text, number, date (by selection).
How to use it
- Identify the key column in your main table.
- Open Lookup from Table from the Combine and Get group on the XLMind Plus tab.
- Pick the source table, the matching column, the field to return, and exact or fuzzy matching.
- Confirm; the results are written to the columns right of your main table, as values or as the XLMIND_LOOKUP formula.
What it produces
Results are written to the columns to the right of your main table.
Source data
The source table is left unchanged.
How it differs from similar tools
Compared with find-and-replace rounds, it processes the whole selection in a single pass with no skipped cells, and one step reverses it if needed.
Good to know
Protected cells refused.
Limitations
Protected cells refused.
Also
Formula mode writes the fill-down-safe XLMIND_LOOKUP function; fuzzy matching is chosen as High, Medium or Low rather than a raw percentage.
Frequently asked questions
- Where does the result go?
- Results are written to the columns to the right of your main table.
- What happens to invalid or unexpected values?
- Text-safe (codes preserved '@').
- How are blank cells handled?
- Not-found/ambiguous → localized text.
- Does the result stay linked to the source?
- The result is a snapshot of the data at run time; after bigger edits, run the tool again for a current view.
- Any known limits?
- Protected cells refused.
Works well with
- To return several columns at once, use Multi Lookup
- To see the records that do not match, use Compare Two Lists
- To fix text-stored numbers that break matches, use Text to Numbers
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.