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

[skylanetk]

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". 

[#2]

@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.

[#3]

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

[#4]

@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