If formula returns # from A1 then looks at B1 then C1 until finds not #

[batexcel]

Hello,

In Col D1 down - I have this formula =(A1)


In Col A I have


#
10
20
#
#
30

In Col B I have

#
#
#
10
#
30

In Col C I have

1
#
#
10
50
#

And basically I need a formula that looks at A1 and if it returns x then looks at B1 and if still returns x then looks at C1 but if it returns a value in A1 then the formula ignores whatever is in B1 / C1.

Col D would look like this

1
10
20
10
50
30

[AliGW]

How about this?

=IF(A1<>"",A1,IF(B1<>"",B1,C1))

[batexcel]

Hello, that works! although my results do actually return # not a blank so amended it slightly to the below.

=IF(D4<>"#",D4,IF(E4<>"#",E4,F4))

Thank you though!

[batexcel]

I tried to add reputation but I guess you answered me last time and I need to spread some around before I can but again big thanks

[AliGW]

I interpreted # as a blank cell!

No worries. Simple stuff.

[batexcel]

Hi - was going to start a new thread but I think you can help with your expertise...

When the below formula returns 000 I want it to return blank instead

=TEXT(IF(C3<>"#",C3,IF(D3<>"#",D3,E3)),"000")


Furthermore, if this formula returns _________________ then I want it to return blank instead also

=LEFT(I17&REPT("_",5),5)&LEFT(J17&REPT("_",4),4)&K17&LEFT(L17&REPT("_",5),5)&LEFT(M17&REPT("_",3),3)