google sheets
I have a Google Sheet with two tabs. Tab A has IDs and a place where I want to fill a column. Tab B has the Same IDs and the data I want to fill into Tab As blank column. I want to auto-populate the Tab A Column with the data from Tab Bs column.
In practice, I have a dataset (tab A) with place names and IDs, and a data set (tab b) with IDs and Population. I want the population to fill into Tab A based on the matching IDs.
Yes. It is Possible. Just follow some simple steps:
A new window will openup and choose spreadsheet option .Here,you can write custom functions which looks like
Here you write functions (for more info,https://developers.google.com/apps-script/your_first_script#requirements)
2.You create a function that will open your Spreadsheet that contains behaves like directory. A sample function
function readRows()
{
var sheet = SpreadsheetApp.openById("0AszINz88nA9hdEkxa1FIS0wta1FLS2NPUzAyU0lOV1E")
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var values = rows.getValues();
for (var i = 0; i <= numRows - 1; i++) { var row = values[i]; Logger.log(row); } };
For more info,https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#open(File)
You can Run and Test by pressing Run and selecting function, (it may require permission).
You can view the results in Log Window by Opening View->Logs.
That,it now you can use that function in that cell.
I'll have a guess that:
=vlookup(A2,Tab2!A:B,2,0)
in Tab1 B1 and copied down might suit.
Best Answer
you probably want this:
=ARRAYFORMULA(IF(LEN(A2:A); VLOOKUP(A2:A; 'Tab B'!A2:B; 2; 0); ))which means that
IFID fromTab Bis found inTab A, formula will return2(second) column from rangeA:BofTab Bin sorted order based on IDs in A column ofTab A- hence that0here is demo spreadsheet: https://docs.google.com/spreadsheets/d/