| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula to copy from a cell
Dear all,
i was given array formula below earlier which will find matches between AB and CD and then print "yes" in A {=IF(SUM(IF(B8&C8=D$2:D$200&E$2:E$200,1,0))0,"yes ","")} i want to edit where it says "yes" so that if there is a match then copy data from F into A please see attached example (A14) any help is really appreciated thank you Last edited by Legolas : May 5th 10 at 07:07 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i copy a colored cell to another cell using a formula | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
| When I copy a formula to another cell, I get the value of the ori. | Excel Worksheet Functions | |||
Threaded Mode
