Compare two columns for same amounts

[jasonhuibers]

I have two excel columns in one work book. There are a list of accounts in ColumnA and a list of accounts in ColumnC. I need to identify which account # in Column A exist in Column B as well...

How can I do this using VBA?

 

[mintjulep]

You can do this without VBA using the MATCH() function.

In the simplest form:

In this example consider that you have 100 rows, 1 through 100.

In any empty column, row 1 enter

=MATCH(A1,B$1:B$100)

Copy that down 100 rows

Any row with a number and not an "N/A" has a match.

 

[jasonhuibers]

Column A | Column B
1 3
3 4
8 6


The function should return 3 as 3 can be found in both columns...

 

[SkipVought]

The Match fm returns the relative offset in the lookup range. That is all U need.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[sxschech]

This article has a formula that will show you if it is matched or not as well as what row the match is on.

http://www.articlejobber.com/tutorial/match_function_excel_20060219_2.html