Matching

[ericcamingao01]

How to match a cell to a group of data and classify that to the classification of the group it belongs?

Example:

I need to match "John" in the list of students and once I find his name, it will identify which class he belongs. > John - Spanish Class

[#2 · Accepted solution]

@ericcamingao01 

Let's say you have a list of students and groups in A1:B100 of the worksheet Students:

On another sheet, you enter a student name in cell A2.

In B2, enter the formula

=IFERROR(VLOOKUP(A2, 'Students'!$A$2:$B$100, 2, FALSE), "-")

This can be filled or copied down if required.

 

[#3]

@Hans Vogelaar Thank you for your help.