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,

	Process 1	Process 2	Process 3	Process 4	Process 5	Process 6
Method A	0	0	0	1	1	0
Method B	1	1	0	0	1	0
Method C	1	1	0	1	1	0
Method D	1	1	1	1	0	0
Method E	1	0	0	1	0	0
Method F	1	0	1	0	0	0
Method G	0	0	1	0	0	1

<tbody>
</tbody>

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