=IF(P11="Y",K11,"") Enter this in AE11. Enter this in AF11
=IF(P11="Y",L11,"")

The "" at the end tells Excel to put a space in the cell if the condition is
not met.

Hope this helps,

Carole O

"sari pratiwi via OfficeKB.com" wrote:

I need to transfer datas from cells K11 and L11 to AE11 and AF11 based on
the answer of P11. For example if P11 is Y then the data from K11 & L11
will transfer to AE11 & AF11, but when P11 is N, then the data would not
transfer. How do I create a formula for that?