giving text result in a column

[CharneLewis]

Hallo! As seen in column C (Soffit Formwork Chosen), there is only one result. This is to show which soffit fromwork to use. I want this result to show in column K (Final Layout). What formula can I use to do this?

So in the Final Layout I only want it to show the result in cell 3. This should be the final answer. (ingore the number 1 in the cell 3 column K (Final Layout), i tried something, but got stuck)

 

[AlanY]

try in cell K3 and copy down

=if(d3=1,c3,"")

 

[CharneLewis]

Hallo, that works but it is limited to cell 3 col C (soffit formwork chosen) only - i need a formula that will give me the result when the text is in cell 35 col C for instance (there are 35 options).

Also, i would rather not want to use the "IFS=" FUNCTION.

 

[Peter_SSs]

It is hard to see what those other values in column C are. If they are "-" characters, then try

=FILTER(C3:C37,C3:C37<>"-","")

 

[Peter_SSs]

It is hard to see what those other values in column C are.

For future samples, consider XL2BB

 

[CharneLewis]

Thank you, that worked. I wil use XL2BB next time.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.