If(and( using vlookup

[brooksc29]

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?

 

[rallcorn]

Is "PITCHERScompLIST" a defined Name Range? If it isn't, that's where your problem lies. You need to be referring to a range of cells.

The concept you're using works - I tested it using this formula:
=IF(AND(VLOOKUP(A1,A6:C7,2,FALSE)=0,VLOOKUP(A1,A6:C7,3,FALSE)=0),"",VLOOKUP(A1,A6:C7,2,FALSE))

 

[brooksc29]

Yes, it is a named range... I realize now why I am still getting 0 back in some circumstances... stupid mistake by me. The AND function requires it to be true for both cases, and that's essentially what I need it to do, just going to have to live with a few 0's on occasion.

thanks for your help

 

[scottylad2]

change your And to an Or then if 0 is allowed