How to match two cells and display yes or no

[jpullen88]

Hello,

I am trying to run a function that will check if cells in A and B match and then return a yes/no answer. Sometimes cell B may be blank and I would like it to list that as no. I have tried using match and If, but the best I can do is to get a Yes and #N/A which would work but I'd like it to be better.

For example,

A - B - C
a25 - a25 - Yes
b34 - c14 - No
c22 - - No

Thank you
Jason

[Sam Capricci]

if you are just looking across values in the same rows, you could use =IF(A2=B2,"Yes","No") and that should be enough.

[Fotis1991]

Please Login or Register  to view this content.

[jpullen88]

That function is giving me the error asking if I wanted to create a formula or if not put a ' in front of the = sign. Also, with some other thought I think I need something that will give more results. I am checking two lists of seals and sometimes they match (abc123 & abc123 = Yes), mismatch (abc123 & cba321 = No/mismatch), blank (one or both boxes are blank = Missing/Unassigned).

[jpullen88]

Oh brother... I think I just overanalyzed the equation. Thanks!

[Sam Capricci]

so is your issue solved or is there still a problem? If solved, please mark the post as solved using the thread tools dropdown at the top of the post and you can certainly thank (all) those who've helped you by clicking on the *Add Reputation below their posts, it is a nice way to thank them and it is how we advance on this forum.