| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Linear Mode
