I have "sheet1=Tue 6 11 2013 9 00 AM" (as Destination) and "sheet2=All Computers_AP1" (as Source) & "sheet3=All Computers_ADASIAPAC" (as Source). Problem is i'm not sure to use which Formula can sort out those result/row indicating 'Disabled' and fall that result under sheet1[Column F (for ..._AP1)] and [Column G (for ..._ADASIAPAC)]?
OR
in sheet1[Column F, showing an result say something like example:- 'Disable in 'AP1' or 'Disable in both'
Code i use to used but not able making it work
=IF(AND(ISERROR(VLOOKUP(A:A,B:B,1,0)),ISERROR(VLOOKUP(B:B,A:A,1,0))),"Disabled "&A2&" and "&B2,IF(ISERROR(VLOOKUP(A:A,B:B,1,0)),"Disabled in AP1 - "&A2,IF(ISERROR(VLOOKUP(B:B,A:A,1,0)),"Disabled in ADASIAPAC - "&B2,"Disabled in Both")))
Bookmarks