Multiple Lookup Values

[seguin85]

Hi,

I have two tables similar to the following:
1.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Code[/TD]
[TD]op1[/TD]
[TD]op2[/TD]
[TD]op3[/TD]
[TD]op4[/TD]
[TD]op5[/TD]
[TD]op6[/TD]
[TD]op7[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ABC123[/TD]
[TD]XY[/TD]
[TD]none[/TD]
[TD]ZZ[/TD]
[TD]WR[/TD]
[TD]none[/TD]
[TD]none[/TD]
[TD]LUG[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]XYZ789[/TD]
[TD]none[/TD]
[TD]none[/TD]
[TD]ZZ[/TD]
[TD]none[/TD]
[TD]LUG[/TD]
[TD]XY[/TD]
[TD]none[/TD]
[/TR]
</tbody>[/TABLE]
In this table each of the options has a drop down from a defined list.

2.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Step#[/TD]
[TD]XY[/TD]
[TD]XX[/TD]
[TD]WR[/TD]
[TD]LUG[/TD]
[TD]FSJ[/TD]
[TD]ZZ[/TD]
[TD]PSN[/TD]
[TD]WEI[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Step1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Step2[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[DSCfromCFA]

G'day seguin85,

A little more information may help get an answer.
Where do you want the "1" to appear if the conditions are met?
Do you only want one "1" or is it a "1" for every time the conditions are met for each option?

Cheers

shane

 

[seguin85]

It will be on a second sheet, but in column I on table 1 will do and I can reference that from that page. Also, I just want 1 if any conditions are met and 0 if none are met. Thanks!

 

[Peter_SSs]

Can you state what the results for your sample data should be and set out the steps that you would do manually to get those results?