How to match or compare row wise between two excel files.

Question

[alvea.tasneem]

Hello,

I have two different excel sheets (each have a single column) containing two different data sets respectively, I need to match or compare these two datasets row-wise. Which excel command would help me fulfil this task? At the same, are there any other programming language or linux commands that can make this task easier?

P. S. The two datasets that I have to compare have nearly 20,000 rows each.

Thank you for your consideration, I look forward to you kind help.

Sincerely, Ms. Alvea

[Friederike]

are there any other programming language or linux commands that can make this task easier

Yes. awk, sed, grep, perl, Python, R -- all of these will likely be more useful in those circumstances. If you want more specific help, you'll have to more specific about the tasks you want to achieve and what you've tried already.

[cpad0112]

you can use either vlookup or if function in excel, for comparison. If you can post data (not images), some one here will be able to help addressing the issue.

[Joe]

This is pretty much exactly what the tool join is intended to do.