Does a particular number appear

[khank]

I'm want see when a "0" appears in one of the 3 columns (A, B, C) does a 3, 6, and 9's appear in the following rows (A, B, C)

Example: If this row contains a "0"
A3: 0 B3: 5 C3: 4

In the following row: Does this row contain a 3, 6, or 9? If it does the answer is "YES"
A4: 6 B4: 7 C4: 4

So, yes a "6" appears in the following row.

See sample, I "manually" implemented the "YES" or "NO" in column D

I've been looking through your past threads with no luck - any suggestions?

[NBVC]

Try, in D3:

=IF(ISNUMBER(MATCH(0,A2:C2,0)),IF(OR(ISNUMBER(MATCH({3,6,9},A3:C3,0))),"YES","NO"),"")

copied down