Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab.

=IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”)

​Hi All, I am trying to formulate a formula to lookup two values. One is the tag number and the other the date and then it should return the test results in column 4 of the test results tab. =IFERROR(VLOOKUP(A3, Table10, 1, FALSE)+VLOOKUP(X3, Table10, 2, FALSE)=VLOOKUP(A3,Table10,4,FALSE), “Not Tested”)  Read More

​