Forum Discussion
Past cells into visible cells
I have one excel sheet with student ID numbers. This is only active students. I have another excel sheet with all students past and present. I would like to get the student ID numbers of the active s...
It sounds like you need to use a lookup function. Try something like:
=INDEX(master student list ID column, MATCH(student identifier, master student list identifier column, 0))
Of course you'll need to find a name, email address, or other way of cross-identifying the students between the two lists.
=INDEX(master student list ID column, MATCH(student identifier, master student list identifier column, 0))
Of course you'll need to find a name, email address, or other way of cross-identifying the students between the two lists.