Aug 27 2020 12:58 PM
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".
Aug 27 2020 01:25 PM
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.
Aug 27 2020 05:13 PM
@Juliano-Petrukio Thank you it appears to have worked. I was putting the ""marks around F2 also.
Aug 27 2020 05:29 PM - edited Aug 28 2020 03:23 AM
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