formula for two tables, possible sumifs

[batjl9]

Hi all

I have attached a sheet which explains what I am looking for. It is a possible sumifs formula, but whenever I try and set it up it returns value error.

Thanks
Gemma

[teylyn]

Hello,

in H2

=INDEX($C$2:$C$6,MATCH(F2&G2,INDEX($A$2:$A$6&$B$2:$B$6,0),0))

copy down.

cheers,

[batjl9]

thanks that works perfectly.

Gemma