Hi,
I have two tables similar to the following:
1.
<tbody>
</tbody>In this table each of the options has a drop down from a defined list.
2.
<tbody>
</tbody>
What I want is a formula that will return 1 if any of the options in the #1 table have a 1 in the #2 table or return 0 if none of the options are met.
Any suggestions on where to get started?
I have two tables similar to the following:
1.
A | B | C | D | E | F | G | H | |
Code | op1 | op2 | op3 | op4 | op5 | op6 | op7 | |
1 | ABC123 | XY | none | ZZ | WR | none | none | LUG |
2 | XYZ789 | none | none | ZZ | none | LUG | XY | none |
<tbody>
</tbody>
2.
A | B | C | D | E | F | G | H | I | |
1 | Step# | XY | XX | WR | LUG | FSJ | ZZ | PSN | WEI |
2 | Step1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 |
3 | Step2 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 |
<tbody>
</tbody>
What I want is a formula that will return 1 if any of the options in the #1 table have a 1 in the #2 table or return 0 if none of the options are met.
Any suggestions on where to get started?