text in a range of values and text

[AmandaSS]

Hi,

I have a row with 3 cells. 1 contains a text the other 2 contain 0.
In A4 I would like to have a formula that gives me the text as a result.

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]A2
[/TD]
[TD]A3[/TD]
[TD]A4
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]oil
[/TD]
[TD]oil
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[TD]gas
[/TD]
[TD]0
[/TD]
[TD]gas
[/TD]
[/TR]
[TR]
[TD]ccgt
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]ccgt
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks
Amanda

 

[Aladin Akyurek]

D1 (not A4), copied down:

=IFERROR(LOOKUP(REPT("z",255),$A1:$C1),0)

 

[AmandaSS]

Thanks Aladin!of course it works!
This works also for the other post I added previously

 

[Aladin Akyurek]

Thanks Aladin!of course it works!
This works also for the other post I added previously

You are welcome. Thanks for providing feedback.

 

[István Hirsch]

Give this formula a try too (enter in D1):

=SUBSTITUTE(A1&B1&C1,0,"")