get value of previous cell

V

villandro

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
 
T

Tom Hutchins

Try this in column E (change 1 to correct row number):

=IF(AND(D1=A1,F1=C1),B1,0)

Hope this helps,

Hutch
 
J

Jacob Skaria

Apply this formula in E1

=IF(AND(A1=D1,C1=F1),B1,"")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching only once 3
Excel VBA macro, search - accumulate - delete original 0
lookup two different variables 0
Lookup an exact Value with a range 8
Help with lots of formulas 3
Transpose columns to rows using first columns repeated. 7
Returning 1 of 4 values if conditions are met 4
Formula to copy related information from sheet 1 to sheet 2 0

Top