SOLVED

Matching

%3CLINGO-SUB%20id%3D%22lingo-sub-1870843%22%20slang%3D%22en-US%22%3EMatching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870843%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20match%20a%20cell%20to%20a%20group%20of%20data%20and%20classify%20that%20to%20the%20classification%20of%20the%20group%20it%20belongs%3F%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EI%20need%20to%20match%20%22John%22%20in%20the%20list%20of%20students%20and%20once%20I%20find%20his%20name%2C%20it%20will%20identify%20which%20class%20he%20belongs.%20%26gt%3B%20John%20-%20Spanish%20Class%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870843%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870992%22%20slang%3D%22en-US%22%3ERe%3A%20Matching%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863686%22%20target%3D%22_blank%22%3E%40ericcamingao01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20have%20a%20list%20of%20students%20and%20groups%20in%20A1%3AB100%20of%20the%20worksheet%20Students%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0012.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232543i8F12BDC879C3DE96%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0012.png%22%20alt%3D%22S0012.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOn%20another%20sheet%2C%20you%20enter%20a%20student%20name%20in%20cell%20A2.%3C%2FP%3E%0A%3CP%3EIn%20B2%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(A2%2C%20'Students'!%24A%242%3A%24B%24100%2C%202%2C%20FALSE)%2C%20%22-%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0013.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F232545i643BE1EC055FC4C0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0013.png%22%20alt%3D%22S0013.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20or%20copied%20down%20if%20required.%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
Best Response confirmed by ericcamingao01 (New Contributor)
Solution

@ericcamingao01 

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

 

S0012.png

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), "-")

 

S0013.png

This can be filled or copied down if required.

Highlighted

@Hans Vogelaar Thank you for your help.