Thursday, May 27, 2010

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

No comments: