ExcelBanter - formula to copy from a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - formula to copy from a cell (https://www.excelbanter.com/excel-worksheet-functions/263084-formula-copy-cell.html)

Legolas

formula to copy from a cell

1 Attachment(s)

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

bala_vb

Quote:

Originally Posted by Legolas (Post 951135)

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

Legolas

Quote:

Originally Posted by bala_vb (Post 951136)

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

bala_vb

Quote:

Originally Posted by Legolas (Post 951217)

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

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.

All times are GMT +1. The time now is 07:16 PM.