Validate students name and ss# on two seperate spreadsheets?

  • Thread starter Thread starter Joann
  • Start date Start date
J

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
 
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.
Click to expand...
You should use something like VLOOKUP and UPPER or LOWER to convert the
string case before doing the compare.
 
Back
Top