Excel field comparisons

C

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
 
O

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.
Click to expand...

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.

--
 
Top