How to combine 3 formulas?

I have these 3 formulas in 3 different cells. the first two formulas are the same but look at different cells. The third formula looks at the first two formula cells looking for a "yes" and then outputs a yes or no. The idea is for the first two formulas to look at two different sources for a match and the third formula to be a defining answer if there was a match or not within the first two sources.

=IF(ISNUMBER(FIND(TEXT($I2,"000"),$G2)),"Yes","No")
=IF(ISNUMBER(FIND(TEXT($I2,"000"),$O2)),"Yes","No")
=IF(COUNT(MATCH("yes",$J2:$K2,0)),"Yes","No").

If you want the formulae simply to be combined into one, returning 'Yes' if $I2,"000" is found in either G2 or O2, then this will do it:

=IF(OR(ISNUMBER(FIND(TEXT($I2,"000"),$G2)),ISNUMBER(FIND(TEXT($I2,"000"),$O2))),"Yes","No")

There might be better ways of searching and/or combining though, depending on exactly what you're wanting to achieve.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Originally Posted by Aardigspook

If you want the formulae simply to be combined into one, returning 'Yes' if $I2,"000" is found in either G2 or O2, then this will do it:

=IF(OR(ISNUMBER(FIND(TEXT($I2,"000"),$G2)),ISNUMBER(FIND(TEXT($I2,"000"),$O2))),"Yes","No")

There might be better ways of searching and/or combining though, depending on exactly what you're wanting to achieve.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

This worked great thanks.

You're welcome and thanks for the rep.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.