Find matching data in two worksheet columns

S

scootter

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?
 
S

scootter

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)
 
Top