rsbidinger
New Member
- Joined
- May 29, 2019
- Messages
- 8
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
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