This example demonstrates how to update multiple cell values after a user selects an item in the editor. In the example, when you select a new value in the "Name" column, the values in the "Address" ...

Five formulas, fewer clicks, and a lot less spreadsheet suffering.