Using if statement for cells with VLOOKUP equations

[KarenLeukenhause]

I have two cells with the following equations:
H3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,13,FALSE)," ")
I3=IFERROR(VLOOKUP(A3&TEXT($A$1,"m/d/yyyy"),'CLABSI_Raw'!$A$1:$M$300,10,FALSE)," ")

In an adjacent cell, I am trying to use an if statement
J3=if(and(H3<1,I3<1),"yes","no")

I am not getting a return in cell J3.

Would you happen to know what I am doing wrong?

[slx]

" " = white space
"" = Nothing, which can be interpreted as 0

[KarenLeukenhause]

I made the changes you suggested, but I still don't get a value in J3. Any other thoughts?

[newdoverman]

I added a set of () to your formulae. ( is added just after VLOOKUP and the ) just before CLABSI..... and they both worked:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The formula in J3 then worked just fine.