Match text string with other text string

I'm trying to compare a very large amount of data with other data in a spreadsheet.

What I want to do is take a text string like and see if it matches anywhere else in the spreadsheet:
"Fireflies, Owl City"

I have tried using the exact function and a few others, but haven't been able to achieve the desired results.

What I would like is for the program to automatically state whether there is a match in the spreadsheet based on the text strings in another column or row.

For an example of what I mean, see the attached spreadsheet.

Please note that in this case this function will not work because it is not guaranteed to be in the same order.

Anyone have any suggestions?

If you need in wich row is new word you need to write:

=MATCH(A2,A3:A10000,0)+ROW(A2)

I'm a little confused as to how this function works.

Here is what I'm currently looking at (attached).

I just sorted a new set of the songs to see if it would work.

What is the 29?

Look here.. is this it?

Sample (1).xls

Yeah that works, but I was hoping there would be an easier way to do that (that way it would be easier to repeat without all the typing and such).

Thanks for your help.