software

Is there a formula that I can use to see if numbers (some are Alphanumeric)
match. ie

A B
5 7
9 4
7 1

I want colums A3 and b1 to say they match and display Y in column C on
either line.

One way:

=IF(OR(COUNTIF(B:B,A1),COUNTIF(A:A,B1)),quot;Yquot;,quot;quot;)

Copy down as far as necessary.

Note, however, that this will be ambiguous if more than one match is
associated with a row (e.g., B1 matches A3, and B3 matches A22).
In article gt;,
quot;ggantquot; gt; wrote:

gt; Is there a formula that I can use to see if numbers (some are Alphanumeric)
gt; match. ie
gt;
gt; A B
gt; 5 7
gt; 9 4
gt; 7 1
gt;
gt; I want colums A3 and b1 to say they match and display Y in column C on
gt; either line.

Hi,

You may try the following array formula (Ctrl Shift Enter)

=IF(OR(EXACT(A1,$B$1:$B$3)),quot;Yquot;,quot;Nquot;)

Copy the formula down.

Regards,

Ashish Mathur

quot;ggantquot; wrote:

gt; Is there a formula that I can use to see if numbers (some are Alphanumeric)
gt; match. ie
gt;
gt; A B
gt; 5 7
gt; 9 4
gt; 7 1
gt;
gt; I want colums A3 and b1 to say they match and display Y in column C on
gt; either line.