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