Excell

%3CLINGO-SUB%20id%3D%22lingo-sub-506299%22%20slang%3D%22en-US%22%3EExcell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506299%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehi%20all%2C%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20with%20my%20Excell%20query.%3C%2FP%3E%3CP%3EI%20want%20to%20copy%20the%20vaule%20in%20D3%20to%20I3%20if%20cell%20E3%20has%20a%20Y%20in%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-506299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506567%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506567%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F330888%22%20target%3D%22_blank%22%3E%40Match811%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20in%20cell%20I3%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3DIF(E3%3D%22Y%22%2CD3%2C%20%22%22)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ESo%20if%20E3%20is%20yes%2C%20the%20contents%20of%20D3%20will%20be%20put%20into%20I3%2C%20if%20it%20is%20not%20then%20then%20I3%20is%20blank.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ECheers%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EDamien%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509741%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509741%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help.%3C%2FP%3E%3CP%3EThe%20formula%20worked%20perfectly%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatch811%3C%2FP%3E%3C%2FLINGO-BODY%3E
Match811
New Contributor

 

hi all,

Can anyone please help with my Excell query.

I want to copy the vaule in D3 to I3 if cell E3 has a Y in it

 

Thanks

2 Replies

Hi @Match811 

 

Try this in cell I3:

 

=IF(E3="Y",D3, "")

 

So if E3 is yes, the contents of D3 will be put into I3, if it is not then then I3 is blank.

 

Cheers

Damien

Hi @Damien Rosario 

 

Thank you very much for your help.

The formula worked perfectly

 

Kind regards

 

Match811