Updating values in a specific table column, and specified row

[Dominicus]

I have a table where left-most column holds a unique ID for each row.
To the right of the uniqueID column, I have several columns with attributes for each ID:

|UNIQUEID|FAMILY|VOLUME|TARGET_COMPLETION_DATE|ACTUAL_COMPLETION_DATE|
|ProdA |Widget|2,000 | 3/4/2017 | 2/17/2017 |
|ProdB |Carrots| 300 | 5/5/2017 | -blank- |
|ProdC |Towels| 770 | 12/22/2017 | -blank- |



I use this master table to track completion %, and summarize progress according to attributes (using SUMIFS(...) and such) in a separate reporting sheet.

Others send me updates listing the subset of ID's which have changed status in one of the columns. This update sheet will list the new value to be loaded for the UniqueID and Column they wish to update.

For example, I'd get something like this:

|UNIQUEID|ACTUAL_COMPLETION_DATE|
|ProdB | 9/21/2017|


Is there an easy way to reliably load these new cell values according to only the rows of the stated UniqueIDs and the referenced column name?
All the columns I accept value updates are loaded with values (not formulas).

Thank You!

[dflak]

This could be done with VBA, but I suggest a better input from the people sending you the updates like the picture below. This way, they can send multiple updates in one message. You can control the ID and Item with Data Validation.

[Dominicus]

I wanted to avoid a VBA macro.
I ended up doing a variant to what you propose:
There's only a few columns where I get updates from users.
For each column I receive updates, I setup a sheet to record the input into a separate table.
These input tables have a couple columns: the ID/index from the main_table, and the field being updated. In my case, it's completion dates.
Instead of trying to update completion dates on the main_sheet column, I filled each column with lookup functions that check the corresponding input table for the value.
If not found, the cell reports blank. If found, it shows the completion date from the matching input table.
Now, whenever I get reports of new records being completed, I just append them to the bottom of the update table that corresponds to the column they're reporting on. The formulas on the main table collect this info and display it in the appropriate cols/rows so I can do my progress reports.