Returning Blank Cells as errors when matching.

Hi Forum,

I'm trying to perform a match on two columns. Every cell in column A has data (even if it's just a zero) where only some cells in column B contain data. Is there a way I can match the two columns where matching data shows in column C as 'TRUE', non-matching data shows as 'FALSE', and cells in column B which are blank show something else (even if they are just blank).

The reason for this is I would like to differentiate between data that is incorrect from data that is missing.

Thanks.

Could you post some sample data?

=if(b1="","",a1=b1)

Sample Data:
Sample Data.png

Column A represents data I expect to find
Column B represents data found via an audit
Column C is where I would like the result, and in a similar format to the one presented.

Apologies but I cannot provide the actual data involved as it is sensitive.

Thanks again.

@ ragulduy
I tried your solution but it does not return 'FALSE' statements for mismatched data. It's either 'TRUE' or blank. I'll play with that for a but and try to work it.

Duplicate Post, Apologies.

Hi,

The formula seemed ok when I tried, I've made it work like your example in the attachment.

SOLVED

Thanks ragulduy. Saved me loads of work.