Comparing 2 columns

[johnnycasali365]

HI,

I'm trying to compare strings in 2 columns, but I haven't figured out how to make it work.

I've tried the VLOOKUP function and adding a new rule with MATCH function to highlight the ones missing in the list A, without any luck in any of the approaches

I really appreciate any help you can provide.

R

[#2]

@johnnycasali365 

I could not find either VLOOKUP() or MATCH().

First, delete ALL the blank rows!

=COUNTIFS(Table7[Eurest],[@PUERTA])=0

[#3]

Thank you sir, all sorted now!