Forum Discussion
johnnycasali365
May 27, 2022Copper Contributor
Comparing 2 columns
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
- Detlef_LewinSilver Contributor
I could not find either VLOOKUP() or MATCH().
First, delete ALL the blank rows!
=COUNTIFS(Table7[Eurest],[@PUERTA])=0
- johnnycasali365Copper ContributorThank you sir, all sorted now!