Excel field comparisons

[CG]

I would like to compare a range of data against another
range of data:

1) The first range contains numerous names
2) The second range containts select names from #1
3) I want to pull out the matching names from #1 based on
the names listed in #2.

Is this possible with the IF function or another function?

Ultimately, I want to be able to pull all of the matched
information into a separate spreadsheet and then export
it into an Access database for further analysis.

Thought, comments, words of wisdom?
CG

 

[JE McGimpsey]

Take a look at

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

 

[onedaywhen]

...

1) The first range contains numerous names
2) The second range containts select names from #1
3) I want to pull out the matching names from #1 based on
the names listed in #2.

Is this possible with the IF function or another function?

Ultimately, I want to be able to pull all of the matched
information into a separate spreadsheet and then export
it into an Access database for further analysis.

You are talking about an INNER JOIN of #1 and #2. You can use SQL with
ADO and the OLE DB provider for Jet to query worksheets in an Excel
workbook. If you are using a Jet database in MS Access it may make
more sense to query the workbook direct.

--