Comparing Concatenate Cells

[tpierce]

Hi All,

I am having issues comparing 2 cells that I have used the Concatenate function & Mid function to combined City, State. I am using a basic IF statement to compare the 2 cells. My question is when they have the same information in both cells the function reads "NO" however if they are blank it reads "YES", suggesting it is not reading the text to compare. Any thought on how to end round this?

@CURRENT LOCATION FORMULA =IFNA(MID([@[CRNT LOC PULL]],FIND("of",[@[CRNT LOC PULL]],1)+3,50),"")
@FROM FORMULA =IFERROR(CONCATENATE([@[FROM CITY ]]," , ",[@[FROM ST]]),"")

COMPARE FORMULA =IF([@[CURRENT LOCATION]]=[@FROM],"YES","NO")

 

[dermie_72]

add an if statement around it saying, if the current location is "" then "Blank" or some other output you choose.

=if(([@[CURRENT LOCATION]]="","BLANK",IF([@[CURRENT LOCATION]]=[@FROM],"YES","NO"))

Then it wont consider blank cells in the logic

 

[Fluff]

Hi & welcome to MrExcel.
If your formula is returning "No" then the cells are not exactly the same. Maybe a matter of leading/trailing spaces.

 

[tpierce]

Hi & welcome to MrExcel.
If your formula is returning "No" then the cells are not exactly the same. Maybe a matter of leading/trailing spaces.

Thank you, you were correct, I had an extra space that I failed to catch.

 

[Fluff]

Glad we could help & thanks for the feedback.