Nov 19 2020 03:25 PM
What I'm trying to do is not among the examples in the Help section.
I want to say IF cell #1 contains the word "YES", copy the value of cell #2 into cell #3, where "cell #3" is the cell containing the formula I need.
In the screen shot supplied, in J149, because I49 is a "YES", I want the 6 in F149 to appear in (be copied to) J149. You can see what I tried, but it returns an error message. Anyone can help? I'm guessing there's some punctuation mark that needs to surround the "F149"?
Nov 19 2020 03:39 PM
SolutionNov 19 2020 03:43 PM
Hi there,
Please note attached file.
I think it can help you.
P.S. If you fond my answer as your best solution, please mention it.
Nov 19 2020 04:15 PM
Thank you, Ilgar, I see what you did.
Interestingly, I achieved what I needed with a different solution.
Nov 19 2020 03:39 PM
Solution