Adding a 3rd INDEX check

=IFERROR(INDEX('MyOsh Dump'!$E$4:$E$4978,IFERROR(MATCH('ERT Roles Expiry Dates'!C5&'ERT Roles Expiry Dates'!$H$3,'MyOsh Dump'!$A$4:$A$4978&'MyOsh Dump'!$B$4:$B$4978,0),MATCH('ERT Roles Expiry Dates'!C5&'ERT Roles Expiry Dates'!$H$1,'MyOsh Dump'!$A$4:$A$4978&'MyOsh Dump'!$B$4:$B$4978,0))),"")

I have this above formula working perfectly to import a cell date if conditions are met, however I need to add in another check which i cant get to work.

This currently returns the date from 'MyOsh Dump'!$E$4:$E$4978' if either of these matches are correct in the index match:
'ERT Roles Expiry Dates'!C5 and 'ERT Roles Expiry Dates'!$H$3
'ERT Roles Expiry Dates'!C5 and 'ERT Roles Expiry Dates'!$H$1

I am trying to add in a 3rd criteria which then checks:
'ERT Roles Expiry Dates'!C5&'ERT Roles Expiry Dates'!$H$2


Does anyone have an idea on how to add in this 3rd match check? Wherever i try to add it I get errors or too many/too few arguments.

Thanks

The initial formula can be adjusted to be:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Shorter option:

Please Login or Register  to view this content.