Question description:
This user has given permission to use the problem statement for this
blog.
Paste Question: I want to paste information from one tab in Google sheets to another and have it automatically match with the line/name it was associated with on the previous tab
Solved by T. A. in 31 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/10/2018 - 09:33
Have a nice day!
User
08/10/2018 - 09:33
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit#gid=0
Excelchat Expert
08/10/2018 - 09:33
Welcome to ExcelChat!
Excelchat Expert
08/10/2018 - 09:33
I see that your question is about matching the data. I will help you with the problem and explain the solution afterwards.
Excelchat Expert
08/10/2018 - 09:33
Before we get started, this is a reminder that our policy is one problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
08/10/2018 - 09:33
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User
08/10/2018 - 09:33
Hi! Can you request access to that Google sheet? That's where the data is
Excelchat Expert
08/10/2018 - 09:34
Can you send the link with the edit access?
User
08/10/2018 - 09:34
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit#gid=0
User
08/10/2018 - 09:34
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit?usp=sharing
Excelchat Expert
08/10/2018 - 09:35
In your Google Document, please press Share -> Get a shareable link -> and choose the edit rights
User
08/10/2018 - 09:35
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit?usp=sharing
Excelchat Expert
08/10/2018 - 09:36
This link requires to request an access. You can share the link, by which I can have the access at once, without sharing my mail (because it violates our policy)
User
08/10/2018 - 09:37
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit?usp=sharing
User
08/10/2018 - 09:37
That's the only sharing link I can provide. If you request access I'll grant it immediately
User
08/10/2018 - 09:37
I haven't had an issue with it before...
User
08/10/2018 - 09:39
??
Excelchat Expert
08/10/2018 - 09:39
One moment, I have to clarify this question
Excelchat Expert
08/10/2018 - 09:39
In general, sharing our emails is forbidden
Excelchat Expert
08/10/2018 - 09:39
This action will share my email, so I need to ask if I have the right to do it
Excelchat Expert
08/10/2018 - 09:40
Could you share a shareable link? You can destroy think link after the session
User
08/10/2018 - 09:41
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit?usp=sharing
User
08/10/2018 - 09:41
That is the shareable link
User
08/10/2018 - 09:41
I've done this with 3 others before and have never had this be an issue
Excelchat Expert
08/10/2018 - 09:41
You can obtain the shareable link in this way:
Excelchat Expert
08/10/2018 - 09:41
please press Share -> Get a shareable link -> and choose the edit rights
User
08/10/2018 - 09:42
I did
Excelchat Expert
08/10/2018 - 09:42
Then you copy the link from the window
User
08/10/2018 - 09:42
That is the shareable/editable link
User
08/10/2018 - 09:42
https://docs.google.com/spreadsheets/d/1zVmbc8gCliaZ8AlBWNhsMdFhKZ8lDT08y8O1-QFiVTM/edit#gid=0
User
08/10/2018 - 09:42
That's the same link I sent initially
Excelchat Expert
08/10/2018 - 09:43
Okay, sorry for the delay, since there is no answer right now, I will try to do it in this way
User
08/10/2018 - 09:43
In what awy?
Excelchat Expert
08/10/2018 - 09:43
I requested an access
User
08/10/2018 - 09:43
Just granted
Excelchat Expert
08/10/2018 - 09:44
Okay, now could you please describe the problem which we need to solve?
User
08/10/2018 - 09:45
I want to copy the School # from Tom Davis tab to the CDE tab and have it align with the district column
User
08/10/2018 - 09:45
Basically a short-cut instead of having to copy/paste one-by-one
Excelchat Expert
08/10/2018 - 09:46
So you want it to automatically appear in the right place?
User
08/10/2018 - 09:46
Exactly
Excelchat Expert
08/10/2018 - 09:47
Right now there are no numbers in the Tom Davis tab
Excelchat Expert
08/10/2018 - 09:47
Oh, you mean column H, right?
User
08/10/2018 - 09:48
Total SFL Target School #
User
08/10/2018 - 09:48
Yes H
User
08/10/2018 - 09:48
Sorry for confusion
Excelchat Expert
08/10/2018 - 09:48
Based on which column should it appear on the next tab? I see you have columns A and B there
Excelchat Expert
08/10/2018 - 09:48
We can match the required result by one of them
User
08/10/2018 - 09:49
I want column H from Tom Davis to appear in column F on CDE
User
08/10/2018 - 09:49
But if I paste regularly it won't be accurate or match
Excelchat Expert
08/10/2018 - 09:51
I can make a solution, which will show Total SFL Target School # based on the District, for example
Excelchat Expert
08/10/2018 - 09:51
Will it solve your problem?
User
08/10/2018 - 09:51
Let's try it
Excelchat Expert
08/10/2018 - 09:52
I sent an edit access
Excelchat Expert
08/10/2018 - 09:55
As I can see, In Districts in column A you have the county data, right?
Excelchat Expert
08/10/2018 - 09:55
And in column B you have the city
User
08/10/2018 - 09:56
No, the county is in column H or G depending on tab
Excelchat Expert
08/10/2018 - 09:56
Yes, but what data is in Districts tab in columns A and B?
Excelchat Expert
08/10/2018 - 09:57
You want to have there the result in column F, and as I understand, it should be connected with these two columns, right?
User
08/10/2018 - 09:57
Correct
Excelchat Expert
08/10/2018 - 09:58
Okay, please check the solution in column F
Excelchat Expert
08/10/2018 - 09:58
What it does:
Excelchat Expert
08/10/2018 - 09:59
It takes the value from column A, finds its position in Tom Davis tab in column H, and then return the value from Total SFL Target School # in the same row
Excelchat Expert
08/10/2018 - 09:59
When you see N/A, it means that it couldn't find it in column H (for example, it doesn't exists there, or you used different spelling)
User
08/10/2018 - 10:00
Okay but can you do it to the CDE tab as requested?
User
08/10/2018 - 10:00
Just ignore the "Districts" tab
Excelchat Expert
08/10/2018 - 10:00
Oh, big sorry, I thought the result is expected there
Excelchat Expert
08/10/2018 - 10:01
Just few minutes
User
08/10/2018 - 10:01
Thanks!
Excelchat Expert
08/10/2018 - 10:02
Put it there, now the solution is based on the District
User
08/10/2018 - 10:02
That's perfect! Thank you!
Excelchat Expert
08/10/2018 - 10:03
The logic is the same - it searches the District from column A in the Tom Davis tab, and then return the proper school numbre
Excelchat Expert
08/10/2018 - 10:03
My apologies for the delay at the start, I just didn't have such experience before (despite I work here quite long), so I didn't know how should I act
User
08/10/2018 - 10:03
I understand, thanks for the help!
Excelchat Expert
08/10/2018 - 10:04
You are welcome, it was a pleasure to assist you! If it happens that you have any Excel or Google Sheets problems in future, please don't hesitate to reach us again.
Excelchat Expert
08/10/2018 - 10:04
You may now end the session, I would highly appreciate if you rate our session at the end and leave some feedback. Have a nice day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.