If cell contains the word "filled" then.......

%3CLINGO-SUB%20id%3D%22lingo-sub-1617229%22%20slang%3D%22en-US%22%3EIf%20cell%20contains%20the%20word%20%22filled%22%20then.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617229%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20column%20G%20with%20either%20the%20word%22filled%22%20or%20%22unfilled%22%20in%20it.%20I%20want%20to%20add%20a%20column%20that%20returns%20the%20value%20in%20column%20F%20if%20column%26nbsp%3B%20G%20contains%20%22filled%22%20or%20nothing%20if%20it%20contains%20the%20word%20%22unfilled%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1617229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617277%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20the%20word%20%22filled%22%20then.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617277%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746290%22%20target%3D%22_blank%22%3E%40skylanetk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20how%20are%20your%3F%20I%20will%20try%20to%20help%20you%20with%20the%20following%3C%2FP%3E%3CP%3EIf(G2%3D%22%3CSPAN%3Efilled%22%2CF2%2C%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPaste%20this%20formula%20and%20fill%20down%20as%20per%20your%20needs.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617617%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20the%20word%20%22filled%22%20then.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3BThank%20you%20it%20appears%20to%20have%20worked.%20I%20was%20putting%20the%20%22%22marks%20around%20F2%20also.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617619%22%20slang%3D%22en-US%22%3ERe%3A%20If%20cell%20contains%20the%20word%20%22filled%22%20then.......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746290%22%20target%3D%22_blank%22%3E%40skylanetk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20good%20to%20hear%20from%20you.%3C%2FP%3E%3CP%3EIf%20you%20feel%20that%20I%20deserve%2C%20please%20hit%20the%20Like%20button.%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EDon't%20forget%20to%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have column G with either the word"filled" or "unfilled" in it. I want to add a column that returns the value in column F if column  G contains "filled" or nothing if it contains the word "unfilled". 

 

3 Replies

@skylanetk 

Hello, how are your? I will try to help you with the following

If(G2="filled",F2,"")

 

Paste this formula and fill down as per your needs.

 

 

@Juliano-Petrukio Thank you it appears to have worked. I was putting the ""marks around F2 also.

@skylanetk 

That is good to hear from you.

If you feel that I deserve, please hit the Like button.

Don't forget to mark as Official/Best Answer to help the other members find it more

Thank you