If columns match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Lookup 2nd & last match with two conditions 6
lookup second / last match with two conditions 1
With F1 value, look at A, if match or partial match return B 5
Match and delete rows on two different sheets from reference numbers 4
Finding dynamic maxima 8
Count column b if column a equal cell value 7
Scrabble Value calculation for Welsh words 0

Back
Top