Nov 10 2020 01:16 AM
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
Nov 10 2020 02:00 AM
SolutionLet'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.
Nov 10 2020 02:00 AM
SolutionLet'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.