Forum Discussion
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
Does this do what you want?
Hi Hans, it is exactly what I need but the formula does not work on my version of excel. I have Excel 2013. I see you have{ } in front and at end of formula but as soon as I press enter this disappears and then the formula does not work.
You have to confirm the formula by pressing Ctrl+Shift+Enter. That turns the formula into a so-called array formula. You'll see { } around the formula in the formula bar to indicate that it is an array formula.
- 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
