Using Concatenate and If Statement... Help Needed...

[Offroadracer_814]

I have this formula currently. =CONCATENATE("Scheduled to Ship"," ",TEXT(V2,"m/d/yy"))

However, Column V also has values that state "No Match". How can I get No Match as my return value instead of my current return of Scheduled to Ship No Match?

Thanks in Advance!

Kevin

 

[dreid1011]

Perhaps this:

=IF(V2<>"No Match",CONCATENATE("Scheduled to Ship"," ",TEXT(V2,"m/d/yy")),V2)

 

[Rick Rothstein]

I have this formula currently. =IF(V2="No Match",V2,CONCATENATE("Scheduled to Ship"," ",TEXT(V2,"m/d/yy")))

However, Column V also has values that state "No Match". How can I get No Match as my return value instead of my current return of Scheduled to Ship No Match?

Maybe adding what I show in red above?

 

[Offroadracer_814]

Thanks you two. Both worked.

Now, I am going to attempt to learn from this. And then try to add an if statement if there is a blank cell in column V return it as a blank cell. So I maybe asking that question tomorrow (or later this week) if I can not figure it out. I have no VBA experience. Just learning by this board, a few co workers and reading language in the Macro when I record it.