Friday, May 28, 2010

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)

No comments: