ConfigMgr Learn it and work it
=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)
=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)
| 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")
| 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")
