Concatenateifs

Originally Posted by ZmeY

Hello I'm looking for a function that can return me a list of strings matching specific criteria s. Anyone knows how to do it?

Can you offer an example?

Perhaps something like the following:

=TRIM(IF(A1=B1," hi","") & IF(C1=D1," world", ""))

It results in "hi", "world" or "hi world". The key is the leading space before each option, using TRIM to removing the leading space.