Formula for data comparison in Excel
=INDEX($B$2:$B$6,MATCH($D2,$A$2:$A$6,0))
B - information trying to find (A student ID for example)
D2 - column to compare from (Our list)
A2 - Column to compare to (the master list)
As mentioned, your output will be the student ID's for all the students in our list.
Blackbaud Community
Connect and collaborate with fellow Blackbaud users.