Satisfy multiple criteria

[alanlambden]

Hi,

I have two sets of data, each set has several columns of data. I want to be able to flag any rows that have two numbers that are identical? Here is an example:

https://imge.to/i/vgKLRV

I hope that link work let me know if it doesn't.

I want to flag the right column (M) only if the numbers in column B matches exactly with the number in column K AND the number in column C matches column L. If either dont match, then leave blank.

PS, is there an easy way to see if the numbers differ by less than 5? This could go in the column N

 

[alanlambden]

Thanks so much, I really appreciate your time and effort