Find more than one item

Question

I am wondering if it is possible to use the search function for more than one item - meaning - I have a list of 200 cells (Acct #'s) in one worksheet, and I need to identify them in another worksheet that holds thousands of lines of data. Is there a way to identify the 200 specifics out of the thousands without searching each individual acct #? I appreciate your help!

Answer

You cannot use the search function, but you can use COUNTIF to do this - if you do a COUNTIF of your data against the other sheet you will get a zero return for a non match and a non zero return (usually one but if you have duplicate data...!) for a match - you can then filter on this.