Hi folks
Can you provide me the correct syntax for the "AND" command below.
ie If "HP" is found in one field and "DL380" is found in another field then this record must relate to a "HP Proliant DL380" server etc etc...

Thanks
Conor



Function Server(pVal As String, pVal2 As String) As String

  If InStr(pVal, "DL380") AND (pVal2, "HP") Then
  Server = "HP Proliant DL380"
  
 ElseIf InStr(pVal, "DL340") AND (pVal2, "HP") Then
  Server = "HP Proliant DL340"
  
  ElseIf InStr(pVal, "DL580") AND (pVal2, "HP") Then
   Server = "HP Proliant DL580"
     
Else
ServerType = "Hardware Not Defined"
End If

End Function