Attached is my example workbook, some columns are left blank because that information is not important to this question. Essentially I want to create a formula/vba code that searches the Raw Data sheet. In this sheet I want to search Column G for the key word "missing" and at the same time I want to search column I for the keyword "paper". If both are found in the same row, I want to return the value of that row from column D. So in the attached workbook, I want the formula to find "missing", and "paper" and then output the ID Code value of 25 then also find and output the value of 75 because that also has "missing", and "paper" in its row. I want a list of all ID numbers that match these criteria to populate in the Analysis sheet of the workbook. Thanks for the help in advance!
Bookmarks