formula to copy from a cell

  • Thread starter Thread starter Legolas
  • Start date Start date
L

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


+-------------------------------------------------------------------+
|Filename: test2.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=139|
+-------------------------------------------------------------------+
 
Legolas;951135 said:
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
Click to expand...

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


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
 
bala_vb;951136 said:
After editing the formulae, select the entire formulae in the formula
bar and select cltr+shift+enter.
Click to expand...

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


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
 
Hi

{=IF(SUM(IF(B2&C2=D$2:D$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
 
Back
Top