Show blank if "x" or "X", else run a VLOOKUP

[rsbidinger]

Hello, I'm trying to put in a formula to output the cell blank if marked 'x' or 'X', else run a VLOOKUP.

How do I do this? Essentially, I'm trying to combine the following...

Here's my IF statement:
=IF(OR(H12<>"X",H12<>"x"),result,"")

Here's my VLOOKUP:
=VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE)

Thank you for your help.

Ryan

 

[Sanjeev1976]

Try:

=IF(H12="x","",IF(VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE)=0,"",VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE)))

OR

=IF(OR(H12="x",VLOOKUP($C11,Blue!$C11:$O$500,7,FALSE)=0),"",VLOOKUP($C11,Blue!$C11:$O$500,7,FALSE))

 

[tyija1995]

Okay one more question...

It's showing zero because the VLOOKUP sees a blank cell. If it's a blank cell, is there a way to tell it to show blank instead of zero? Thanks.

Nest it within another IF statement will suffice:

=IF(IF(H12="x","",VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE))=0,"",VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE))

 

[rsbidinger]

Perfect!!!!

Thank you for saving me hours of research & trial & error.

Try:

=IF(H12="x","",IF(VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE)=0,"",VLOOKUP($C11,'Blue'!$C11:$O$500,7,FALSE)))

OR

=IF(OR(H12="x",VLOOKUP($C11,Blue!$C11:$O$500,7,FALSE)=0),"",VLOOKUP($C11,Blue!$C11:$O$500,7,FALSE))