Simple INDEX/MATCH formula that I just cant get to work

[mattbarb]

=INDEX(IC!G6:G,MATCH(1,($J8=IC!$E$5:$E)*($Z$8=IC!$E$5:$E),1)0,3)

I'm trying to return result which is 3 columns to the right of the match but it just doesn't work. Any help appreciated.

 

[Fluff]

Is this for Excel or for Google Sheets?

 

[mattbarb]

Is this for Excel or for Google Sheets?

Excel

 

[Fluff]

Ok, it's just that the ranges you used will never work in Excel, but do in Sheets which is why I asked.
In the Match function you checking to see if col E equals two different values, which it never can.
Can you please describe in words what you are trying to do.