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.
Auto Insert Address on adjacent cell
google spreadsheets