Index Match Multiple Criteria - Two Tabs

[elizabethCatKat]

I am trying to do an index match. I want to match the Vendor ID and Max Manual Date in the Audit Tab to the corresponding row in the Quality Tab to get the Manual Rating and then to match the Vendor ID and Max of EtQ Audit Date to get the EtQ Rating. None of my formulas work. Can someone point me in the right direction? I'm tried several formulas on-line and I'm getting nowhere. Thank you!

[PaulM100]

Something like this: =IFERROR(INDEX(Quality!$C$2:$C$467,MATCH(Audit!A2&Audit!B2,Quality!$A$2:$A$467&Quality!$B$2:$B$467,0)),0)
Array formula entered with Ctrl+Shift+Enter
Do the same for Max of EtQ