index with match

[ezzat]

You need an equation on the sheet to extract the salary when two conditions are met

 

[ezzat]

You need an equation on the sheet to extract the salary when two conditions are met
View attachment 120644

 

[Joe4]

You need an equation on the sheet to extract the salary when two conditions are met
View attachment 120644

Welcome to the Board!

Is there some sort of question here?
If so, please provide more detail.
Here is a link with some tips on how to ask a good, complete question: Guidelines

 

[ezzat]

You need an equation on the sheet to extract the salary when two conditions are met
View attachment 120644

 

[ezzat]

 

[Joe4]

No need for Index/Match here.

If you had Excel 2016 or newer, you could simply use a SUMIFS formula like this:

=SUMIFS(C:C,A:A,G15,B:B,H14)

But if you are really using Excel 2010, you can use SUMPRODUCT, like this:

=SUMPRODUCT(--(A:A=G15),--(B:B=H14),C:C)

 

[ezzat]

=SUMIFS(C:C,A:A,G15,B:B,H14)

Thanks

 

[Joe4]

You are welcome.

If the SUMIFS formula worked for you, that implies that you are probably using an Office version newer than the 2010 shown in your profile.

If that is the case, I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)