=IF(AND($P4=5,$Z4="AIDS")=TRUE,"DAIDS",VLOOKUP($N4,CANS!
$A$2:$D$149,3,FALSE))
If the value in P4 = 5, AND the value in Z4 = "AIDS", then give me the value
"DAIDS" in the cell, BUT if either of those two criteria are not met, then take
the value in N4, look for it in the range CANS!$A$2:$A$149 and then bring back
the associated value from the same row in the range CANS!$B$2:$C$149, which
happens to be the 3rd column of data (hence the 3) in the range
CANS!$A$2:$D$149.
=IF(AND($AA13<>"DAIDS",$Z13="AIDS")=TRUE,"ARR",$Z13)
If AA13 = "DAIDS" AND Z13 = "AIDS" then put "ARR" in the cell, BUT if either of
those is not the case, then put the value from Z13 in there.
