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.

A1	A2	A3	A4
0	0	oil	oil
0	0	0	0
0	gas	0	gas
ccgt	0	0	ccgt

<tbody>
</tbody>

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,"")