Conditional Indexing

[DeepanshuS]

I have tried to post this question earlier, but it didnot show up.

My problem is to find a relative straight forward way to determine what methods are valid for a given set of process required. For example,
[TABLE="width: 734"]
<tbody>[TR]
[TD][/TD]
[TD]Process 1[/TD]
[TD]Process 2[/TD]
[TD]Process 3[/TD]
[TD]Process 4[/TD]
[TD]Process 5[/TD]
[TD]Process 6[/TD]
[/TR]
[TR]
[TD]Method A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method B[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method C[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method D[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method E[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method F[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Method G[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


Method A is applicable for Process 4 and Process 5 alone.

If I had to select a combination of different Processes, (Say Process 2, Process3), How will I be able to list different methods that are common for both the process.

Any help will be much appreciated.


EDIT: I wanted to make a check box selector where I can list the Processes to be carried out and the result will be the common methods that are available for the selected processes.

 

[Vinoth_Shob]

Instead of check box add two combobox in your user form


Private Sub ComboBox1_Change()
With ComboBox2
If UserForm1.ComboBox1.Value = "Process 1" Then
For k = 2 To 8
If Sheet1.Range("B" & k).Value = 1 Then
.AddItem "" & Sheet1.Range("A" & k).Value & ""
End If
Next
End If
End With
End Sub


Private Sub UserForm_Initialize()
With ComboBox1
.AddItem "Process 1"
.AddItem "Process 2"
.AddItem "Process 3"
.AddItem "Process 4"
.AddItem "Process 5"
.AddItem "Process 6"
End With




End Sub