Lookup

This Analytics Edge wizard lets you quickly lookup values from another Table or Worksheet that share an index column with the current table.

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.