Comparing two lists to see where they match

[Matt Harris]

Hi,

I need to compare two lists, one a reference list and one a list of collected data (plant species names). How can I compare them so that those data I have collected which are in the reference list are somehow 'flagged up' or even aligned with the corresponding name in the reference list?

If this has already been asked and answered, please point me to the thread, as I can't find any.

Thanks