Update table 1 column with the changes made to referenced table 2

Hello,

It's a simple task, but I am just stuck on writing the proper expression.

I have two tables in one Google Sheet, referenced together with unique "ID"s. I am using one, "EEs", as an employee record and the other, "History", to record the historical changes to the 'EE' table. So, if I want to change a date in the 'EE' table, I open the EE record and scroll down to "Add" under the EE table which opens the 'History' form where I enter the column to be updated and the update value.

Can someone please help with the expression to write to carry over the updated value from the History table to the appropriate column in the EE table and insert the value? 

Here is the sheet:  https://docs.google.com/spreadsheets/d/12JgGVkOjhMRwxjmXd1AKD1TdQVMp_mglN3k0xcMan9s/edit?usp=sharing

Any help is truly appreciated!

Daryl

0 8 650
8 REPLIES 8
Top Labels in this Space