This Analytics Edge wizard lets you update the current table from entries with matching rows in another table or worksheet.
It is typically used to update a master list with transactional items, and includes options to ignore empty update fields and to only update a field if it is empty.
Update from Table – select a worksheet or previously named table from the drop down list. The worksheet must be in the same workbook, and data must start in cell A1 with a header row. If you want to use a table in memory, use Table Name to create the reference.
Select Key Columns – select columns that will be used to align the two tables together. All values from all selected columns must match for a row to match.
Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).
Replace only empty cells – do not update existing values unless they are empty.
Ignore update if empty – if the reference table contains empty cells, do not modify the matching row in the current table.
Add new columns from update – add any columns from the reference table that do not exist in the current table.
Add new rows from update – add rows from the reference table with values in the key columns that only exist there.
Blog article: Using the Update Function
Updated in v10.