Forum Discussion
Janedb
Jul 04, 2024Iron Contributor
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...
- Jul 04, 2024
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
SergeiBaklan
Jul 04, 2024MVP
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
Janedb
Jul 05, 2024Iron Contributor
Thank you!, This one is working without the Ctrl+Shift+Enter.