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)),"Y","")

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 ,
"ggant" wrote:

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.

Hi,

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

=IF(OR(EXACT(A1,$B$1:$B$3)),"Y","N")

Copy the formula down.

Regards,

Ashish Mathur

"ggant" wrote:

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.