Forum Discussion
Solved
Vlookup with 2 scenarios
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. =IFER...
If to modify slightly
=IFERROR(INDEX(Table10[Result], MATCH(1, INDEX( (Table10[Tag]=A2)*(Table10[Date]=X2),0,1), 0)), "Not Tested")it shall work without Ctrl+Shift+Enter
HansVogelaar, thank you very much. It didn't work until I did the Ctrl+Shift+Enter in the correct order.
If to modify slightly
=IFERROR(INDEX(Table10[Result], MATCH(1, INDEX( (Table10[Tag]=A2)*(Table10[Date]=X2),0,1), 0)), "Not Tested")it shall work without Ctrl+Shift+Enter
- Thank you!, This one is working without the Ctrl+Shift+Enter.