PDA

View Full Version : MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL



pivotguy
06-01-2016, 04:34 AM
I would like to Match "Key1" column from TAB2 and update "KEY1" column of TAB1 only for values where cell values are "NOT FOUND" in TAb1
. See attached file.

pivotguy
06-01-2016, 07:53 AM
Anybody any help?

mdmackillop
06-02-2016, 02:20 PM
Can you add another table on Tab 1 showing the expected result?