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<=1.6,P2>=1.2),AND(E2="P",F2=8.25,P2<=1.5,P2>=1.3),AND(E2="P",F2=9.5,P2<=1.7,P2>=1.3)),"PASS","FAIL") it will only work when i have E2 as a regular text cell. is there a way to run Q2 with the vlookup in E2?