Hi guys,
I am an environmental scientist, and use Excel to help me work out which plant and animal species are protected. On one sheet I have a list of all the species that are protected, and on another I paste in a list of all the species that I found on the site. I have set up a formula to check the 'pasted' list against the 'protected' list on the other sheet, and if a species is protected then it flags it up.

This works fine, however it only works for the first 263 records - if a species is listed in row 264 or over on the 'protected' sheet, then it is never picked up in the list that I paste into the 'pasted' sheet. The formula is exactly the same for all rows, and is as follows:

=IF(ISNA(MATCH(B2,Protected!a, 0)),"","protected")


Can anyone think why it is not working beyond this limit? If it helps I could attach the excel file, but I'm not sure what the rules are about attachments?

Thanks,
Nick