Hi,
I have 2 excel files, 1 and 2 (see attached files)
In 1, there are multiple sheets, named according to group names for students, and in each sheet, there are student names and their group names (two columns: Name and Group).
In 2, there are student names and their scores in many subjects, but without their group name (two columns: Name and Scores).

Now, I want to add a third column to file 2 for group name based on data in file 1, also the names in file 2 are random, so copy paste group names will not make sense

So, I think it requires Match function or something else.
Please any fix or any other idea to fix this issue?

Thanks

Attached Files

	1.xlsx (8.8 KB, 9 views)
	2.xlsx (8.1 KB, 9 views)