excel function question

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 p...