Lookup From (right side) – select the other table or worksheet to use as a reference.
<– Index –> – select the column from the current table (left side) to align with the reference table’s field (right side).
Ignore case – when aligning the columns, ignore upper/lower case differences.
Ignore spaces – when aligning the columns, ignore any difference in spaces in the values.
Add Columns – select the columns you want to pull from the reference table.
If Duplicates – if there is more than one row in the reference table with a matching index value, select how you want to handle duplicate text, numbers and dates (only one aggregated value is pulled into the current table per row.
Updated for v10.