Compare Different Data with Rules

[perrymans]

Is there a better way to compare lists with rules other than lots of nested IF statements?

List A
------
pass
unknown
fail

List B
------
NR (--unkown--)
NF (--pass--)
O (--fail--)

Rules
------
If A=pass AND B=NF then Pass
If A=fail AND B=O then Fail
If A=pass and B<>NF then Pass/Mismatch
If A=fail and B<>O then Fail/Mismatch
etc.

Didn't know if there was some fancier way to accomplish.

Thanks. Sean.

 

[tlowry]

you could use "Select Case" statements like:

Select Case A
        Case Pass
            Select Case B
                Case NF
                    'Pass
                Case Else ' <> NF
                    'Pass_Mismatch
            End Select
        Case Fail
            Select Case B
                Case O
                    'Fail
                Case Else ' <> O
                    'Fail_Mismatch
        End Select
End Select

 

[perrymans]

That'll work I was hoping for something formula-based, but this is easy to organize.

Thanks. Sean.