Copying values between google sheets

by Mrl   Last Updated July 26, 2018 21:03 PM

I have 2 google sheets. I have data on google sheet A and I would like it to automatically transfer some values to google sheet b. For example, I have some email addresses and some data associated with them organized by row. So one row corresponds to one email address. I want to be able to take the existing data (and any data I add) on sheet A and and have it automatically transfer certain values in sheet A to sheet B (matched by columns) such that if I input the email address on sheet B on an email address column in sheet B it will auto populate values from cells corresponding to that email addresses row in sheet A. So once I insert the email address in sheet B it will take the corresponding name of that person in sheet A and input it in the name column I have in sheet B. What type of function would I need to write for this? Sorry if this is unclear.

Answers 1

this could be solved in many ways, one of which is:

=IMPORTRANGE("URL-of-your-spreadsheet"; "Sheet1!A:Z")
July 26, 2018 20:59 PM

Related Questions

LEFT JOIN two and more tables in Google Sheets

Updated January 25, 2019 15:03 PM