Google Sheets linking two sheets using a primary key
I have two sheets that I want to link using a "primary key". At the moment, I have imported from sheet1 into sheet2 some columns using the function
=Sheet1!A1 (for the first cell for instance). My purpose is to complete the data related to each imported line in sheet2. However, sheet1 is shared with other people, thus they can modify the content of a line without deleting or modifying the data I have added in sheet2 (and that doesn't exist in sheet1).
Given the fact that my table has a column 'id' that can be considered as a primary key, how can I add new data in sheet2 in so far as it will be related to the 'id' rather than the position of the line (so if I ever change an id in sheet1 the data I added will be deleted or if I move an id to another line, all the data will be moved too)?
you can use VLOOKUP and bring over data based on ID, like:
=ARRAYFORMULA(IFERROR(VLOOKUP(D:D, Sheet1!A1:B, 2, 0),))
for more columns add them in an array:
=ARRAYFORMULA(IFERROR(VLOOKUP(D:D, Sheet1!A1:B, {2,3,4,5}, 0),))
- Smallest number that cannot be formed from sum of numbers from array
- Group 2d array data by one column and accumulate another column's values in subarrays
- Reverse the order of array elements
- How to log JavaScript objects and arrays in winston as console.log does?
- Overwrite associative elements of one array with another associative array and reverse the array order
- Convert a flat array of delimited values into a hierarchical array
- How to reindex an associative array?
- Set keys of a flat indexed array using the array's values
- Convert two columns in an array of objects into an associative array
- Combine columnar values in each row of a 2d array to form dynamically keyed elements
- Where can I fill an array in Angular?
- Validating an array's length against another array's length using joi
- How can I use the wildcard function in a Word VBA macro with an array?
- How to parse a querystring formatted string?
- Parse a string resembling PHP array syntax into an associative array
- Why does giving a foreach a 3-element array perform 3 iterations?
- Data Class Either Object or Array
- How to Allocate memory from a new virtual page in C?
- Group values of an associative array and accumulate keys as comma-separated values
- Pass comma separated key string and get value of array according to key in PHP
- AssertEquals 2 Lists ignore order
- Finding out how many times an array element appears
- Remove the time substring from an array of datetime strings
- Group associative elements by keys with contiguous dates to create an array of associative arrays
- Parse a string with 3 delimiters and return the keys which contain a qualifying value
- Swift: Pass array by reference?
- PHP append one array to another (not array_push or +)
- Initializing a dynamically-sized Variable-Length Array (VLA) to 0
- Splitting array into groups using typescript/javascript
- Array.Join in .Net?