Help for a newbie... please

[Nancie]

I am trying to create a formula to look at a certain cells, and if
those cells contain the value I am looking for I want to return that
value, look at another cell and return that value as well separated by
a space and so on up to a possibe 5 different return values. I think
this is a nested statement but I just can't figure it out.
EX:

formula cell is C3
if D3 = "acrs" then I want C3 read arcs in the cell with a space, and
if E3 ="brf", then I want to have C3 read arcs brf and so on for up to
5 different reutned values in one cell. Can some on guide me?

Thanks so much.
Nancie

 

[Guest]

Try this:

=TRIM(IF(D3="arcs","arcs ","")&IF(E3="bfr","bfr ","")&IF(F3="abc","abc
","")&IF(G3="xyz","xyz ","")&IF(H3="hello","hello ",""))

The TRIM function is included to remove any trailing spaces.

HTH,
Elkar

 

[Nancie]

Thank you so much... that is exactly what I was looking for and needed.

Blessing!