formula to copy from a cell

[Legolas]

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$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


+-------------------------------------------------------------------+
|Filename: test2.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=139|
+-------------------------------------------------------------------+

 

[bala_vb]

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$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

After editing the formulae, select the entire formulae in the formula
bar and select cltr+shift+enter.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

 

[Legolas]

After editing the formulae, select the entire formulae in the formula
bar and select cltr+shift+enter.

yes i know but what i need is to edit the formula and to copy data from
F
instead of "yes"
thanks


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

 

[Roger Govier]

Hi

{=IF(SUM(IF(B2&C2=D$2$19&E$2:E$19,1,0))>0,F2,"")}

This must still be array entered, so press Control+Shift+Enter (CSE)
after amending.
Do not type the curly braces { } yourself.
When you use CSE, Excel will automatically insert them.
Copy formula down as required