Find matching data in two worksheet columns

G

Guest

I have a worksheet that has two columns of data. The first column contains
the data that I'm trying to match or find in a second column. I then need it
to show me the data that is the same in both columns. What's the best way to
do this?
 
G

Guest

Here's the function I entered. Column A contains the data I want to match or
find in column E. The problem is if the number in column E doesn't match the
number in column A the result shows as the number that's in column E. I've
done something wrong...
=VLOOKUP(A$2:A$33,A$2:E$33,5,FALSE)
 
G

Guest

Okay...let's try this again. I have a worksheet with 5 columns of data. One
column contains about 1000 part numbers and one column contains about 10,000
part numbers. I'd like to find the common part numbers in these two columns.
Is this possible?
 

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

matching & combining data from seperate worksheets 2
Excel Comparing two columns 1
Find matching values 2
Find matching records in two tables using mulitiple criteria 1
matching columns to find differences. 0
Match Function 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
merging two worksheets 3

Top