Would appreciate some help if possible...

I have a excel spreadsheet that is generated with alot of info. In the fisrt column there is a part #(text) with info about that part # in the row. There are in excess of 12000 part #'s. I want to be able to input the info into a template and have only the part #'s that I am interested in show up.( I have a list of these on another worksheet.

Is there a way to search a column for cells that match cells in another grouping?

I'd like the formula to print all the cells that appear in both 'lists' in a seperate column.

Any ideas on how to do this?

Thanks,
Adam