How to use Sumproduct for a table with one criteria in Column and other in Row

[sunilbsrv2k]

Hi all,

I have a table in which 2 criteria are in 2 different columns (F and K). Column F contains the Task Name. Column K contains the Grade A, B or C.

However, I have another table in which the Task name is in Column and the Grades are in a row; the corresponding values w.r.t Task in the corresponding rows below.

I want to get this data from table 2 in table 1. I have done it using Index-Match-Match.

However, I want to know if this is possible using Sumproduct function. I tried but didn't get the required number. Please help.

I have attached screenshots of the two tables:

Table 1:

Table 2:

Thanks,

 

[Bobjg]

Why do you want to change from INDEX/MATCH if it works?

 

[sunilbsrv2k]

because I feel, Sumproduct is simple in usage. I had used Sumproduct in a similar Row/Column issue, it had worked. But this time its not giving the results.