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