Google-sheets – Auto Insert Address on adjacent cell

google sheets

I am trying to create a spreadsheet which enters address automatically on adjacent cell when I type in the company name.

The script will be as I type in company name in cell A1, it will search for matching name in another spreadsheet which I saved the company name and address, then copy the corresponding address back into the adjacent cell A2.

I need this to keep track the job logbook.

Best Answer

You can use a vlookup function

=VLOOKUP(E138,Status!A:K,6,false) E138=the Control or reference number (i.e. name) that will be the same in this sheet and the sheet with your data Status!A:K=the tab that has your data and the columns that the data is in. the first column should be the one that has the reference numbers (i.e. name) 6=the column that has the data you need (i.e. address)

Related Solutions

Google-sheets – Hyperlinks in Google Sheets

The only sense in which a hyperlink can be placed in the middle of a cell is by centering the cell. If what you mean is a cell containing a hyperlink and also other plain text, that is not currently possible.

Parameters can be used in a URL. A URL is simply a string and can be a constant value or can be built up from functions or other cells. For example:

= hyperlink( "https://www.google.com/search?q=" & B2 )

Google Sheets – Auto Date Added to Adjacent Cells When Data is Entered

Use this to add the dates:

Code

function onEdit(e) {
  var aCell = e.source.getActiveCell(), col = aCell.getColumn(); 
  if(col == 2 || col == 4 || col == 6) {
    var adjacentCell = aCell.offset(0, 1);  
    var newDate = Utilities.formatDate(new Date(), 
      "GMT+1", "dd/MM/yyyy kk:mm:ss");
    adjacentCell.setValue(newDate);
  }
}

Example

I've created an example file for you: Adjacent Cell
Add the code to the script editor (Tools > Script editor...), press the save button and you're on the go !!