This sidebar allows you to pull a value from a cell into the sidebar and place a value from the sidebar into a cell.

Add-on logo Spreadsheet Add-on Template by Google