Matching columns

Solved/Closed
KJFin - Jun 2, 2010 at 05:27 PM
 KJFin - Jun 3, 2010 at 11:15 AM
Hello,
I have to an issue with matching columns.

Column A Column B Column C Column D


Column A: This has 300 lines with account #'s
Column B: This has 4300 lines with account #'s
Column C: This has 4300 lines with client #'s
Column D: This has 4300 lines with Balances

I need a formula that will match the 300 accounts in column A with the account #'s in Column B so I can get rid of the 4000 account that do not have a match with any of the accounts listed in Column A.

Please assist.



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 2, 2010 at 05:37 PM
Try this
on column E, in you can have

=IF(ISERROR(MATCH(B2,A:A,0)), 0, MATCH(B2,A:A,0))

This will show the row number of where the account number in a cell of column B, appears in column A. In case the account is not in A column, it will show 0.

You can filter on 0 and delete the rows
1
You are awesome than you very much for your assistance!!
0