I am looking for a formula in excel that will compare to columns of data and
put a result in another column. Basically: "If the number in column A (each
row will have a different number) appears in column E (any row and may even
have multiple occurences), put a Y in column G on the row in which the column
A number appears." Does that even make sense?