Forum Discussion
Solved
Matching
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 ide...
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.
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.
HansVogelaar Thank you for your help.