checking 2 columns information is on another 2 columns on another TAB

[DEEARO]

Hi All,

thank you in advance for your help.

SHEET1: Columns B & C,

check this information is present in

RAW DATA: Columns M & N

would it be possible the formula allows for extra spaces as sheet 1 information is manually entered.

[AliGW]

Simples:

=IF(COUNTIFS('RAW DATA'!M:M,B2,'RAW DATA'!N:N,C2)>0,"YES","NO")

No idea what you mean by extra spaces ... Please elaborate!

Best thing is to have a drop-down selection list, NOT manual entry.

[DEEARO]

YES, drop down menu are very help, however the data is given to me, is there so the formula finds matches which are similar instead of exact match,

[AliGW]

OK, so you need to supply some data that shows the nature of these discrepancies, please. We can't account for every single typo and erroneously added space - I am sure you realise this.

You should still taclke the root issue by telling those who give you the data to get this sorted out.