There is most likely a way to code for all the combinations you have in mind,
Are the number of combinations resolute or changing?
Are the locations of the changes needed resolute or changing?
There are formulas that can populate data validations, as well as macros that can.
Would you post a workbook with ten rows or columns of sample data,
then another sheet with end results after code or formulas do the magic.
for example, if you click in B2 the formula will be inserted...
if the values match you get a 1, if they don't you get nothing
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Row = 2 And _
Target.Column = 2 Then
With Target
.Offset(0, -1).Formula = "=IF(B2=952,IF(C2=5064,1,""""),"""")"
ActiveSheet.Calculate
End With
End If
If Target.Column = 2 And Target.Row = 2 Then
ActiveSheet.Calculate
End If
End Sub
Dream big,
explain in as much detail as you can what your goal is,
then let us go to bat for you.
-mark