Forum Discussion
Running a IF(OR(AND fomula off a Vlookup
in cell E2, i have a Vlookup: =VLOOKUP($C:$C,'Vlookup Scott'!$C$2:$K$10,3,FALSE) and i need to run a If(OR(AND statement in cell Q2: =IF(OR(AND(E2="R",F2=8.25,P2<=1.4,P2>=1.2),AND(E2="R",F2=9.5,P2<...
the Vlookup brings back what i need it to, but the IF(OR(AND does not. it looks like it only works when i enter it manually.
I think i have it. it wasn't reading the numbers as numbers, and instead read them as a text statement off of the vlookup.
Okay, so far so good. I didn't catch why numbers since in your OR formula you compare E2 with texts as "R" and "P". But that doesn't matter if finally it works.
