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
Bookmarks