sunilbsrv2k
Board Regular
- Joined
- May 25, 2018
- Messages
- 73
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,
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,