=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)
No comments:
Post a Comment