Adding a third match to an Index Match Formula

I currently have a spreadsheet with two sheets. The first is my reporting sheet and the second is called Stores.

I currently am using the following formula in the reporting sheet:

=IF(ISERROR(INDEX(Stores!$A$1:$CA$1000,MATCH($A4,Stores!$A$1:$A$1000,0),MATCH(R$3,Stores!$A$8:$CA$8,0))),0,INDEX(Stores!$A$1:$CA$1000,MATCH($A4,Stores!$A$1:$A$1000,0),MATCH(R$3,Stores!$A$8:$CA$8,0)))

What this is doing is looking in my Stores sheet in column A and finding the match in cell A4 in my reporting sheet. It's then looking again in my Stores sheet in row 8 for a match to cell R3 in my reporting sheet. When it finds both criteria it's then giving the value of the column and row that match.

What I need to do is modify the formula to add another matching criteria to look in column F in the Stores sheet and match it with cell C4 in my reporting sheet. The reason for this is that in my Stores sheet column A can have the same value repeated so I need it to also match column F. I would want the result to be the cell in the Stores sheet that matches what is in cell A4, C4, and R3 in the reporting sheet.

Any help would be greatly appreciated. Thanks