Copying a cell but with diferent column...

[xerox0526]

Hi Guys;

I was wondering if it was possible to create a formula so when for example: If Columns A:D were composed just of values and cell E4=A4. When and the value of E4 is entered if it possible for F4=D4.

Have that said;

If E4=A11 F4=D11

So just by changing the value of E4, F4 would recalculate automatically.

Thanks for any help you have..

My Excel is 2007 version..

 

[Roli001]

Try this:

=IF(AND(ISNUMBER(A4),ISNUMBER(B4),ISNUMBER(C4),ISNUMBER(D4),E4=A4),D4,IF(AND(ISNUMBER(A4),ISNUMBER(B4),ISNUMBER(C4),ISNUMBER(D4),E4=A11),D11,""))

Good Luck.