Thread: Index Match 2 criteria

Need to return a value in row "Q" if D3 in "Summary" worksheet = row R in "Raw" worksheet and if E2 in "Summary" worksheet = row G in "Raw" worksheet

so I want to say

=INDEX(Raw!$Q:$Q,MATCH(Summary!$E$2,Raw!$G:$G,0)+MATCH(D3,Rawl!$R:$R,0))

Try this formula in E3 copied down

=IFERROR(INDEX(RAW!Q$2:Q$500,MATCH(1,INDEX((RAW!G$2:G$500=E$2)*(RAW!R$2:R$500=D3),0),0)),"")