get value of previous cell
Apply this formula in E1
=IF(AND(A1=D1,C1=F1),B1,"")
If this post helps click Yes
---------------
Jacob Skaria
"villandro" wrote:
Hi thanks for your help.
ok what i want to accomplish is this
Table 1
Table2
A B C D
E F
10/26/2009 1 $25.00 10/26/2009 $25.00
IF D & F = A & C i want E to have the value of B
by the way
is this possible with an excel formula i tried the conditional IF & And but
not luck yet
i hope somebody could help me thanks
|