What it does
For a value you look up, brings back every matching row from another table, not just the first one, and lists them in a new block. It works in older Excel versions too because it does not need spilling formulas. Your source table is not changed and this runs inside Excel.
Modes
- As values
- As a formula (XLMIND_MULTI_LOOKUP)
- Where the result goes
- Results are written to a new report sheet, as values or a single spilling formula.
- Source data
- The source tables are left unchanged.
Your data is processed on your own computer. Your Excel contents are never shared with AI services.