Concatenate Multiple Cell Values if Condition Is Met

[Kimston]

Attached is a sample of the file

[bluesky63]

Hi Kimston,

upload a sample with the desire answer will be easier for us to provide solution

Thank you !

[Kimston]

Thank you BluSky63 for looking into this. Let me know if the sample helps you.

[bluesky63]

Hi Kimston,

Not sure whether this is what you want, if you got other scenarios then will need to tweak the IF formula with other excel commands

[Kimston]

This is what I'm looking for. I would like to add if K column has the word "no", then the result in N should say, "No action need."
Thank you so much BlueSky63!

[Kimston]

SkyBlue63,
I noticed that in the sample you provide, it didn't include the word or statement in between the result in column N.
I"m looking for an end result as follow:
IF(K2="no","",K2="yes",""&B2&" has "&F2&" PO # "&C2&" it is"&I2&" at"&J2&" to",K2="","")

[bebo021999]

Generally:

=IF(K2="NO","No action needed",CONCATENATE(...))

[Kimston]

bebo, how would you add this in between
&B2&" has "&F2&" PO # "&C2&" it is"&I2&" at"&J2&"
Thank you

[bebo021999]

Is is simple?

=IF(K2="NO","",B2&" has "&F2&" PO # "&C2&" it is"&I2&" at "&J2)

[Kimston]

I was able to use =IF(K2="NO","",B2&" has "&F2&" PO # "&C2&" it is"&I2&" at "&J2&"). the only thing I don't see if I select "NO", is the word "No action needed".

[bebo021999]

=IF(K2="NO","No Action needed",B2&" has "&F2&" PO # "&C2&" it is"&I2&" at "&J2)
Does it work?

[Kimston]

Yes it did. Thank you so much bebo.