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 (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.