Two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two colums: A and B, both containing text. In A I have 15000 rows, in
B I have 1000 rows. I need to identify the rows where values in A also are in
B. How can I do this?
 
One way, in D1:
=NOT(ISERROR(VLOOKUP(A1,$B$1:$B$1000,1,FALSE)))
Fill down to D15000

HTH. Best wishes Harald
 
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

Large Data File Consolidation... 2
countif comparing two columns 4
adding digits with moving decimals 3
Adding numerals with moving decimals 2
copy and past cells found by SUMPRODUCT 1
How do I group and transpose data - macro help needed. 4
Excel Help to copy information from one row at a time to another sheet 1
sumif - if the text has LCI in it 3

Back
Top