Sumproduct formula Error

[Malhotra Rahul]

Hi, Please find here below the link of sample workbook. Where i am trying to fetch the data with the help of Sumproduct formula but it is giving the correct output.

I have mentioned the Expected results in Slip tab.

Any help would highly be appreciated. Thank you in advance.

Regards

https://drive.google.com/file/d/1NTZZy8VZ2LG5CGqmfrSAphW0nBu9qMXB/view?usp=sharing

 

[stumac]

Why are you using sumproduct?

try (non array formula):

Employee name - =INDEX(Data!D:D,MATCH(Slip!I10,Data!B:B,0))
Basic Salary - =INDEX(Data!K:K,MATCH(Slip!I10,Data!B:B,0))

 

[Malhotra Rahul]

Thank you stumac, for your support. Is it possible to get the output by using sumproduct array formula which i am trying to use. So i will come to know where i was mistaken.

 

[stumac]

Not for the employee name AFIAK it must return a number.

You could use a really inefficient sumproduct to return the salary - but that's wont show you where you went wrong... where you went wrong was using sumproduct.

 

[Malhotra Rahul]

it is in the link provided at the top.

 

[Malhotra Rahul]

Experts, can you please help me by using my formula that where I am wrong in the used formula.

Is it possible to get the expected results by using the sumproduct array formula.

 

[JPARKHURST]

it does not appear you are summing anything?

If you are wanting to retrieve information for an employee by looking up their ID in a table, the index,match method Stumac showed you would be the best way.


Thanks,

Jon

 

[Malhotra Rahul]

I feel JPARKHURST, you are absolutely right. Stumac has the perfect solution. Thank you so much Stumac for your perfect solution.