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.
this could be solved in many ways, one of which is: