Create a master table with data from two sheets

[Lija]

Hey guys,

So I need to make a table with data from two sheets.

Sheet 1 has columns: Student ID / Student Name / GPA
Sheet 2 has 2 columns: Student ID / number of classes

I need to make a master table for that has columns: Student ID / Student Name / GPA / Number of classes.

Sheets have a different number of data, so my master table should have only information on students for which we have all the data.


thx for the help! Let me know if sending the file would help.

[Vinodsralian]

Hi, If u send a sample file it would be easier!!

[Pepe Le Mokko]

You can use the VLOOKUP function to retrieve the number of Classes based on student ID

Please Login or Register  to view this content.

[Lija]

Ok, so here is an example of the file.
So I would like to make a table on a new sheet that has the data on Student ID/Name/GPA/Number of classes.
The table should include only the student for which we have all the data.