excel VLOOKUP

=IF(ISNA(VLOOKUP(A:A,'[17.0.xls]BAU Accepted Servers’!$B:$B,2,0)),”Not In BAU servers List”,”Yes server In BAU servers List”) =IF(ISNA(VLOOKUP(A:A,'[17.0.xls]Decommissioned Server List’!$B:$B,2,0)),”Not In BAU servers List”,”Yes Server In Decommissioned list”) =VLOOKUP(A321,'[17.0.xls]Decommissioned Server List’!$B$2:$C$81,2,FALSE)

Yes server In BAU servers List

a a Yes server In BAU servers List (=IF(ISNA(VLOOKUP(A:A,B:B:$B$99,2,0)),”Not In BAU servers List”,”Yes server In BAU servers List”)) b a Yes server In BAU servers List a b Yes server In BAU servers List     =IF(ISNA(VLOOKUP(A:A,B:B:$B$99,2,0)),”Not In BAU servers List”,”Yes server In BAU servers List”)

Thanks to Ajay for recollecting this – Virus Clean with the help of Super DAT File

How to scan for viruses in DOS   Step 1 – Download and Extract the current SuperDAT Files Click on the following link or type the URL into an Internet browser address bar:https://www.mcafee.com/apps/downloads/security_updates/superdat.asp?region=us&segment=enterprise Click the I Agree button (if needed) to verify you have a current support agreement with McAfee. English users, please click the … Read more

Updates Performance Monitor counter : LODCTR

Updates Performance Monitor counter   LODCTR    Updates Performance Monitor counter names and explain text for an extensible counter Usage:    LODCTR [computername] filename        computername is the name of the remote computer.            Local machine is used if computername is not specified.        filename is the name of the initialization file that contains            the counter name definitions and explain … Read more