Value of particular column

[kashish]

Formula for A column
If B = Y then there will be value in C column or D Column (any one column
has value)
Value of C or D should come in A
For example

A B C D

A Y A
B Y B
N
C Y C
N
D Y D

 

[Jacob Skaria]

Formula in A1..

=IF(B1="Y",IF(C1="",D1,C1),"")

 

[Mike H]

Hi,

Put this in A1 and drag down

=IF(B1="y",C1&D1,"")

Mike

 

[kashish]

Thank You

Hi,

Put this in A1 and drag down

=IF(B1="y",C1&D1,"")

Mike