1. I have a list of codes and would like to generate a list of codes that are in Column A from Sheet 1 and not in column A of Sheet2 and return the value in column B from Sheet 1 of the codes that populate sheet3
2. If that is not possible I am looking for a way to generate a list of codes in column a of sheet one if a specific word is found in column b of sheet 1. I would search by the name of the medication. The medication can be listed with an order sentence or without.