| 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 |
|
#2
|
|||
|
|||
|
Quote:
__________________
Thanks Bala |
|
#3
|
|||
|
|||
|
Quote:
instead of "yes" thanks |
|
#4
|
|||
|
|||
Quote:
If you want to edit the formulae, 1. go to cell, and edit formulae manually in A2 cell 2. select the entire formulae in the formula bar and use cltr+sht+enter 3. use cltr +D to copy the formulae till A19. Please refer to attached file that i have modified for you.
__________________
Thanks Bala |
| Reply |
| 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 | |||
Linear Mode
