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...