Compare cells if not blank

Paula Cosentino

Hello,

I'm trying to compare two cells (both containing a city) to see if they match but I don't want blank cells included. Thank you for any help. I'm sure it's easy, but I've already spent waaaay to much time trying to figure it out! 😏

city match.JPG

Sandra Guzman

Hi @Paula Cosentino,

Try this:

=IF(OR([Existing Clinic/Care Site City]@row = "", [New/Updated: Clinic/Care Site City]@row = ""), "", IF([Existing Clinic/Care Site City]@row = [New/Updated: Clinic/Care Site City]@row, "Match", "Not Match"))

All the best,

Sandra

Sandra Guzman

Hi @Paula Cosentino,

Try this:

=IF(OR([Existing Clinic/Care Site City]@row = "", [New/Updated: Clinic/Care Site City]@row = ""), "", IF([Existing Clinic/Care Site City]@row = [New/Updated: Clinic/Care Site City]@row, "Match", "Not Match"))

All the best,

Sandra

Paula Cosentino

You are my new best friend!!! Thank you for taking the time. This is perfect!

Sandra Guzman

@Paula Cosentino,

I am happy to help and also happy to make new friends. 😊

Hope you have a great day!

Sandra