Question description:
This user has given permission to use the problem statement for this
blog.
I have an excel sheet "A" with a column that ID's students with a student number and contains columns with grading data. I have another excel sheet 'B" that ID's students with their student number also with grading data in other columns. I would like to use excel sheet "A" to auto populate grading data into excel sheet "B" based on the matching student ID numbers.
Solved by M. J. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/04/2018 - 12:15
hI
Excelchat Expert
13/04/2018 - 12:15
Thanks for contacting Got it Pro
Excelchat Expert
13/04/2018 - 12:16
Are you there?
User
13/04/2018 - 12:16
yes
Excelchat Expert
13/04/2018 - 12:16
Cool :)
Excelchat Expert
13/04/2018 - 12:16
Are you able to see my Screen?
User
13/04/2018 - 12:16
yes
Excelchat Expert
13/04/2018 - 12:16
Let me create some dummy data for your question.
Excelchat Expert
13/04/2018 - 12:17
I hope this will help you to understand your question
Excelchat Expert
13/04/2018 - 12:18
In one Sheet (A) I just have student Name
Excelchat Expert
13/04/2018 - 12:18
In another Sheet (B) I just have Student name and Marks.
Excelchat Expert
13/04/2018 - 12:18
Now we would like to find Marks.
Excelchat Expert
13/04/2018 - 12:18
Is it Clear?
Excelchat Expert
13/04/2018 - 12:18
??
Excelchat Expert
13/04/2018 - 12:19
Are you there?
User
13/04/2018 - 12:20
yes
Excelchat Expert
13/04/2018 - 12:20
=vlookup(A2,B!A:B,2,0)
User
13/04/2018 - 12:20
yes, reading...
User
13/04/2018 - 12:20
you data
User
13/04/2018 - 12:20
your data
User
13/04/2018 - 12:20
give me a sec.
Excelchat Expert
13/04/2018 - 12:20
ok No problem.
Excelchat Expert
13/04/2018 - 12:22
you can refer the syntax in excel.
Excelchat Expert
13/04/2018 - 12:24
Please let me know your Queries.
User
13/04/2018 - 12:24
okay
User
13/04/2018 - 12:24
can you email me this excel document you just made?
Excelchat Expert
13/04/2018 - 12:24
yes. Sure.
Excelchat Expert
13/04/2018 - 12:24
Not mail. I will share you the document here. you just download.
User
13/04/2018 - 12:25
great thank you, I will need to work with it, I think I can figure it out
User
13/04/2018 - 12:25
okay
Excelchat Expert
13/04/2018 - 12:25
FYI...
[Uploaded an Excel file]
User
13/04/2018 - 12:25
perfect thank you!!!! From U.S. - North Carolina classroom
Excelchat Expert
13/04/2018 - 12:25
Please download this file and check.. If you need any help connect with us again.
Excelchat Expert
13/04/2018 - 12:25
Wow! Cool.
Excelchat Expert
13/04/2018 - 12:26
Request you to provide your valuable feedback and end the session.
User
13/04/2018 - 12:26
okay
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.
