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.