Forum Discussion
If cell contains the word "filled" then.......
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...
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.
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
