Simple Excel Question

This will probably be easy for most to solve, but I have
not been able to figure out a solution.

Here's the set-up:

A simple spreadsheet with two columns. The first column
lists several hundred Student Numbers throughout the
State that have completed a SAT Test.

The second column is a listing of Student Numbers from an
individual School District - some which have taken the
SAT and others that have not.

Here's the question:

How do I get Excel to review each cell in the second
column against all of the cells in the first column and
determine the matches?

Said another way, how do I get Excel to determine whether
each Student Number in the District list has completed
the State SAT Test?

I've tried an IF statement and I've looked at a VLOOKUP
but still have not identified a solution.

Please advise if you have any ideas.

Thanks in advance.


SBH

Hi Scott!

See:
Chip Pearson
http://www.cpearson.com/excel/duplic...tingDuplicates

All you're likely to want for handling Duplicate and Unique problems

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Scott B. Hogle" wrote in
message ...
This will probably be easy for most to solve, but I have
not been able to figure out a solution.

Here's the set-up:

A simple spreadsheet with two columns. The first column
lists several hundred Student Numbers throughout the
State that have completed a SAT Test.

The second column is a listing of Student Numbers from an
individual School District - some which have taken the
SAT and others that have not.

Here's the question:

How do I get Excel to review each cell in the second
column against all of the cells in the first column and
determine the matches?

Said another way, how do I get Excel to determine whether
each Student Number in the District list has completed
the State SAT Test?

I've tried an IF statement and I've looked at a VLOOKUP
but still have not identified a solution.

Please advise if you have any ideas.

Thanks in advance.


SBH

Take a look at

http://cpearson.com/excel/duplicat.htm


In article ,
"Scott B. Hogle" wrote:

This will probably be easy for most to solve, but I have
not been able to figure out a solution.

Here's the set-up:

A simple spreadsheet with two columns. The first column
lists several hundred Student Numbers throughout the
State that have completed a SAT Test.

The second column is a listing of Student Numbers from an
individual School District - some which have taken the
SAT and others that have not.

Here's the question:

How do I get Excel to review each cell in the second
column against all of the cells in the first column and
determine the matches?

Said another way, how do I get Excel to determine whether
each Student Number in the District list has completed
the State SAT Test?

I've tried an IF statement and I've looked at a VLOOKUP
but still have not identified a solution.

Please advise if you have any ideas.

Thanks in advance.


SBH

I just wanted to say thanks to both of you - that link
answered my question.

Have a great week.

Scott B. Hogle
-----Original Message-----
Take a look at

http://cpearson.com/excel/duplicat.htm


In article ,
"Scott B. Hogle"
wrote:

This will probably be easy for most to solve, but I
have
not been able to figure out a solution.

Here's the set-up:

A simple spreadsheet with two columns. The first
column
lists several hundred Student Numbers throughout the
State that have completed a SAT Test.

The second column is a listing of Student Numbers from
an
individual School District - some which have taken the
SAT and others that have not.

Here's the question:

How do I get Excel to review each cell in the second
column against all of the cells in the first column
and
determine the matches?

Said another way, how do I get Excel to determine
whether
each Student Number in the District list has completed
the State SAT Test?

I've tried an IF statement and I've looked at a
VLOOKUP
but still have not identified a solution.

Please advise if you have any ideas.

Thanks in advance.


SBH
.