View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
villandro villandro is offline
external usenet poster
 
Posts: 5
Default get value of previous cell

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