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?

"scootter" wrote:

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)

"Naraine Ramkirath" wrote:

vlookup would be your best approach.
"scootter" wrote in message
...
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?