Cell validation and if valid display from one cell, if not display from the other cell

Hello,

I have a value in one cell that will change between 0 and 1, and I need in a new cell if the value is 0 copy a value from one cell and if the value is 1 then copy from the other cell.

Can you please help me on it.

Thanks in advance.

Thank you very much for the quick response..but unfortunately the above statement isn't working in my case. what I need is
Untitled.png

I have D1 as 0 and I need a formula in G2, if I have D1 as 0 I need value of E1 and if I have D1 as 1 I need to have F1 value in G2...but the above mentioned formula is not working in my case.

Thanks in advance

Try this in G2

=INDEX(E1:F1,D1+1)

Thank you...but not working

=if(d1=0,e1,f1)

Works for me

In what way does it not work for you?
Do you get an error? What error?
Do you get the wrong result? What result did you actually get? What result did you expect, and why?

Can you post an actual book?
Pictures aren't really very helpful.

Hello all

=if(A1=0;B1;C1)

works for me...Thank you all for your support.