Index Match with 2 conditions

[Expal2018]

Hi,

Having an issue with an index match and adding multiple criteria, think it has to be an array but not sure.
Here's the basic index match.

=INDEX('GR 12032018'!C:C,MATCH(B13,'GR 12032018'!G:G))

I need to add a second criteria

=INDEX('GR 12032018'!D:D,MATCH(A13,'GR 12032018'!G:G))

How do i go about merging these?

Thanks

 

[Aladin Akyurek]

What do you mean by merging? Sum two INDEX values?

 

[Expal2018]

Sorry, badly phrased question.
I want pull the result from the index where both conditions are met so would be in the same formulae some how.
The index is the name of the campaign, the top index value is for the phone number, the bottom index is value is for the time of the phone call.

 

[Expal2018]

Sorry, badly phrased question.
I want pull the data from the index where both of the following criteria are met.
(B13,'GR 12032018'!G:G) and (A13,'GR 12032018'!D:D) in the same formula

The index is the name of a client, the G:G is the telephone number and the D:D is the time and date of the call.
Not sure if its an array or if function i'm after

 

[Aladin Akyurek]

Control+shift+enter...

=INDEX('GR 12032018'!C:C,MATCH(1,IF('GR 12032018'!D:D=A13,IF('GR 12032018'!G:G=B13,1)),0))

Try to avoid the whole column references though for reasons of efficiency.