If function

Hey Everyone,

Another easy one for you ...

On sheet 2 I have the following:

C6 =+IF((C5<>""),C$3,"")
D6 =+IF((D5<>""),D$3,"")
E6 =+IF((E5<>""),E$3,"")

etc.

I am sure you all know what it does ... but if not.

So when I put an X in C6,D6, E6 etc.
It takes the value from C3,D3, E3 etc. (once it is populated) and puts it in C6,D6, E6 etc.

But instead of me entering the x on Sheet 2 in C6,D6, E6 etc I want to enter the x on Sheet 1 C4:R4 and carry the x into Sheet 2 C6,D6, E6 etc.
And have the above If function still work.

Thanks in advnace.

If you put x in C6 you'll overwrite your formula, I assume you mean C5, D5, etc

In Sheet2 C5

Please Login or Register  to view this content.

Drag Across to Column R
In C6

Please Login or Register  to view this content.

Drag Across to Column R

Is this what you are after?