Comparing one cell to every cell in another column

  • Thread starter Thread starter ExcelAlex
  • Start date Start date
E

ExcelAlex

I have a workbook that imports data from two separate text files. I wan
to find any matches between the two sets of data, but they will not b
in the same order.

IF
Cell in Column 1 (from data import 1) = Any Cell in Column 2 (from dat
import 2)
THEN
Column 3 = "MATCH"

I'd like to do this for every cell in column 1. The lists can up t
1000 rows long.

If anyone out there can help me, I'd greatly appreciate it!

THANKS!
Ale
 
In C1:

=if(isnumber(match(a1,b:b,0)),"Match","NoMatch")

and drag down.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Compare Two Columns 3
Create if partial match then copy and paste data from one cell to another 1
How Do I Compare one cell to an Entire Column 2
comparing two columns in vba 2
Combine three InputBoxes into one? 7
Remove specific cells in a column. 2
Import multiple workbooks to current workbook in specified row number 0

Back
Top