All solutions Google SheetsMATCH Expert Solution – MATCH Function in Google Sheets

Excel - MATCH Function in Google Sheets - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc