Validate students name and ss# on two seperate spreadsheets?

[Joann]

I am trying to check a long lis of student names & ss# on
a class list on a spreadsheet to a master list on another
spreadsheet.

What functions should I use, information is in both cases
and each row pertains to a student. All columns contain
the same type of information.

Can someone please help?

Thanks

 

[Chris Leonard]

I am trying to check a long lis of student names & ss# on

a class list on a spreadsheet to a master list on another
spreadsheet.

What functions should I use, information is in both cases
and each row pertains to a student. All columns contain
the same type of information.

You should use something like VLOOKUP and UPPER or LOWER to convert the
string case before doing the compare.