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 |
get value of previous cell
=IF(AND(D1=A1,F1=C1),B1,"")
-- Regards, Peo Sjoblom "villandro" wrote in message ... 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 |
get value of previous cell
Try this in column E (change 1 to correct row number):
=IF(AND(D1=A1,F1=C1),B1,0) Hope this helps, Hutch "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 |
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 |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com