Hello,

I have a worksheet of 144484 species locality records for around 600 species. Column A is species name, B is latitude, and C is longitude. I have another column, D, That only contains 471 species names. I need to extract only the records, Column A through C, that correspond to Column D. I have been Trying to use this formula in column E: =IF(ISNUMBER(MATCH(A2, D2:D471,0)),"1","0").
It returns all 0 which would mean there are no matches. I know, however that there are matches because If I enter the same formul but match D2 to anything in A, =IF(ISNUMBER(MATCH(D2,A2:A144484,0)),"1","0"), it returns 1s for all of the 471 species. The only reason I am using this formula is because I am familiar with it so I am open to new suggestions. I was going to sort by column D then extract all records with a "1" in column D. I tried to attach my workbook but it is too large. I can cut it down and attach it but I don`t know how much I should cut it down. Let me know if this doesn`t make sense and I will try to explain better.

Thanks,

Blake