Excel Formula or tool to compare two columns of data

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?

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

On Fri, 14 Apr 2006 08:49:01 -0700, RBS
<[email protected]> wrote:

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

Hi!

>Does that even make sense?

Yes!

Try this in G1:

=IF(COUNTIF(E$1:E$100,A1),"Y","")

Then just copy down as needed.

Biff

"RBS" <[email protected]> wrote in message
news:[email protected]...
>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?

Try this in G1:

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

Copy down as needed.

HTH,
Elkar


"RBS" wrote:

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