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?