Lookup From – select the table or worksheet to use as a reference.
<– Index –> – select the columns from the current table (left) and reference table (right) to align.
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 v8.2.