This Analytics Edge wizard lets you quickly lookup values from another Table or Worksheet that share an index column with the current table.
Key Column – select the column from the current table to align with the reference table’s key column.
Lookup From
Worksheet/Table – select the other worksheet or table to lookup data from.
Key Column – select the key column to use in the other worksheet or table.
Select Lookup Columns – select the columns you want to pull from the reference table.
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.
Duplicate Aggregation
If there are duplicate values that match the key column value, choose how to aggregate the data.
Text Columns – choose how duplicate text column values will be summarized.
Number Columns – choose how duplicate number column values will be summarized.
Date Columns – choose how duplicate date column values will be summarized.