Excel Formula or tool to compare two columns of data

R

RBS

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?
 
P

Per Erik Midtrød

I think you will need to use an ID, ISERROR and VLOOKUP.
Something like this in G1:
=IF(ISERROR(VLOOKUP(A1;E:E;1;FALSE));"";"Y")

Per Erik
 
E

Elkar

Try this in G1:

=IF(COUNTIF($A$1:$A$100,"="&E1)>0,"Y","")

Copy down as needed.

HTH,
Elkar
 
Top