ExcelBanter - If columns match

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If columns match (https://www.excelbanter.com/excel-worksheet-functions/61072-if-columns-match.html)

ggant

If columns match

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.

JE McGimpsey

If columns match

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.

Ashish Mathur

If columns match

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.

All times are GMT +1. The time now is 02:10 AM.