=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)

 

Leave a Reply