Index Match Match not working

[gheyman]

This works: =INDEX(SQD[SourceID],MATCH(SQID[@VendorQuoteID],SQD[Vendor Quote ID],0))
And
This works:
=INDEX(SQD[SourceID],MATCH(SQID[@[ItemID - Trimmed]],SQD[PartNumberTrimmed],0))

But this does not: =INDEX(SQD[SourceID],MATCH(SQID[@[ItemID - Trimmed]],SQD[PartNumberTrimmed],0),MATCH(SQID[@VendorQuoteID],SQD[Vendor Quote ID],0))

I dont see where I am going wrong. I need to match both.

 

[jasonb75]

The second match is for column number, it is not a secondary match for row number (the tooltips tell you this when you are typing the formula). Assuming only 1 row will match both criteria,

=FILTER(SQD[SourceID],(SQID[@[ItemID - Trimmed]]=SQD[PartNumberTrimmed])*(SQID[@VendorQuoteID]=SQD[Vendor Quote ID]),"")

 

[gheyman]

Thank you. I did not realize that.