Do you mean something like this:
Code:
If DataTable.Value("Param1", "Sheet1") = "Something" then
MsgBox "OK"
Else
MsgBox DataTable.Value("Param2", "Sheet2")
End If
