If InStr(1, i.Range("D" & j).Value, "Network") > 0 Or i.Range("D" & j).Value = "Server" Or InStr(1, i.Range("D" & j).Value, "Rack") > 0 Then
this line will pick up if cell contains "network"
is equal to "Server" ie server 1 is skipped
or contains "rack"

reason i used instr is because in your example you wanted Network to be picked up but in the cell it is network devices
i assumed there was other cells network "BLAH"