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)

0 comments:

Post a Comment