I'm trying to say if "Vlookup1"=0 and "Vlookup2"=0, then leave blank, if not, the Vlookup3... however, it's returning 0 and not " ".
=IF(AND(VLOOKUP($L4,PITCHERScompLIST,93,FALSE)=0,
VLOOKUP($L4,PITCHERScompLIST,94,FALSE)=0),"",
VLOOKUP($L4,PITCHERScompLIST,93,FALSE))
what am I doing wrong here?
=IF(AND(VLOOKUP($L4,PITCHERScompLIST,93,FALSE)=0,
VLOOKUP($L4,PITCHERScompLIST,94,FALSE)=0),"",
VLOOKUP($L4,PITCHERScompLIST,93,FALSE))
what am I doing wrong here?