Hello,
I have 3 columns E, F, and G. The cells in columns F and G are formula based that reference another worksheet. They either return an error or a text value.
I need a formula in E3 that will look at F3 and G3 and return a value based on the following conditions:
If F3 and G3 are both errors, show nothing
If F3=G3, show F3
If F3 is an error, but G3 is any text value, show G3
If G3 is an error, but F3 is any text value, show F3
Of note, if both F3 and G3 have text values, they will always be the same value. Below is what I have tried which works in the cases of F3=G3 as well as F3 and G3 both being errors, but not for any other condition.
I appreciate the help in advanced!
I have 3 columns E, F, and G. The cells in columns F and G are formula based that reference another worksheet. They either return an error or a text value.
I need a formula in E3 that will look at F3 and G3 and return a value based on the following conditions:
If F3 and G3 are both errors, show nothing
If F3=G3, show F3
If F3 is an error, but G3 is any text value, show G3
If G3 is an error, but F3 is any text value, show F3
Of note, if both F3 and G3 have text values, they will always be the same value. Below is what I have tried which works in the cases of F3=G3 as well as F3 and G3 both being errors, but not for any other condition.
VBA Code:
=IF(AND(ISERROR(F3),ISERROR(G3)),"",IF(F3=G3,F3,IF(AND(ISERROR(F3),ISTEXT(G3)),G3,IF(AND(ISERROR(G3),ISTEXT(F3)),F3,""))))
I appreciate the help in advanced!